D
David Neil Smith
Hi, I have developed an Access application for a client and now want to allow
them to do some data analysis using Excel. Developing the Excel workbook, I
used a System DSN (without thinking!!) hoping that by using this I could
allow Excel to query the client database - the problem being that they have
their data stored on a network and I do not - hence the relative file paths
to the data are completely different. Of course, the client's workbook
complains that it cannot find 'my data'.
By replacing the workbook with one using File data source names I assumed
that I would solve the problem but it doesn't.
Am I doing something stupid or shouldn't I be able to create a data source
name that becoems the pointer to the database rather than Excel and MSQuery
turning this into a fixed path to the data.
Hope this makes some sense - and may I thank in adavance anyone who can help.
regards
David Smith
them to do some data analysis using Excel. Developing the Excel workbook, I
used a System DSN (without thinking!!) hoping that by using this I could
allow Excel to query the client database - the problem being that they have
their data stored on a network and I do not - hence the relative file paths
to the data are completely different. Of course, the client's workbook
complains that it cannot find 'my data'.
By replacing the workbook with one using File data source names I assumed
that I would solve the problem but it doesn't.
Am I doing something stupid or shouldn't I be able to create a data source
name that becoems the pointer to the database rather than Excel and MSQuery
turning this into a fixed path to the data.
Hope this makes some sense - and may I thank in adavance anyone who can help.
regards
David Smith