Seperating Excel, MS Query from datasources

[Guest]

Hi, I have developed an application using an Acess 2003 db. The client now
wants easier reporting than perhaps is available from Access and so I have
developed an Excel workbook that contains several worksheets with automatic
refreshed queries bringing data from the Access mdb file. Well and good -
though the client's data resides in a different relevant path to mine. I
assumed wrongly that if I used File DSN's to specify the location of the
data, then I the Excel/Query would use the DSN as a pointer rather than
incorporating the actual data path within the worksheets. Is there any way of
writing an Excel workbook that uses DSN's to specify where the data is please?

It's Access and Excel 2003 by the way.

Cheers and kind regards

David Smith

 

[HSNYDER313]

Hi David,

Sorry, I can't help you with your problem.

But, guessing that you are quite young, I will tell you what we were
taught years and years ago in school: There is A RAT in SEPARATE
--- SEP A RAT E .

"Separate", I would guess, is one of the most often mis-spelled words
in the English language.

Good luck with your problem, I am still looking for a solution to
mine.

HARVEY
Providence, RI