How do I link a spreadsheet without getting a multiple DSN/DNS error?

[Chammond]

Hey

Some advice would be handy on how to link a spreadsheet to access without getting a multiple DSN/DNS error?

Thanks
C

 

[welshgasman]

Explain how you are getting that error in the first place?
Where is the Excel sheet in relation to the Acecss DB?

I have linked many an Excel sheet and have never had that error?

 

[Chammond]

Explain how you are getting that error in the first place?
Where is the Excel sheet in relation to the Acecss DB?

I have linked many an Excel sheet and have never had that error?

I am trying to link a spreadsheet as a linked table from a shared drive, but think I am getting an error due to other stuff in the access database also having a linked server as most of it (tables and queries) uses SQL for it to work etc etc.

Not sure how I can get around it?

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

DNS/DSN error when trying to link excel file to access

Hey I�ve been trying to link a spreadsheet to an access data base file, but I�m getting a multiple DNS/DSN error. Does anybody know how to solve the error? thanks C

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.