Microsoft Excel Query

[Graeme155]

Hi

I have written an excel query to import from an Accounting package, using an ODBC driver.

This excel sheet has now been moved to another computer and I need to connect to the datafile, which is in a new area.

The ODBC driver has been setup, but it appears the Query in the Excel sheet has to be changed to find the database. Any ideas on how to change the query to connect to this database appreciated.

Tar

Graeme

 

[bensonsearch]

Hi,
Can you provide sample of code to look at?