Importing ODBC Data .. anywhere??

I

Ignacio

Look, I set up an Excel workbook to import external data from an
existing QUERY file I made. This query file just specifies the name of
the DSN installed on ODBC control panel, no any local path, etc...
because I want this same Excel file to work just the same in another
any machine that has the same file and DSN set up.

But no, it seems that when I complete the import data process, Excel
keeps in mind the path where the external file (it is a CSV text file)
is, So If I move this CSV file anywhere from its original place, even
If I redefine the new location in the DSN configuration... the
workbook does not import the data anymore and gives an error.

This way I cannot reproduce the Excel file with the refreshed data fmo
the CSV although reached to install the same DSN and the CSV and Excel
files in the remote computer... the Excel file in the remote computer
keeps searching the CSV file in the old path even though his new DSN
is well defined...

What could I do to make the Excel file with the dynamic data work on
any computer, with a DSN correctly installed ?

Thanks !

Ignacio
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA macro to auto import new CSV file from fixed directory 1
Forcing Excel to Import .CSV data 2
Export Macro to new Workbook based on Email Address 7
Macro to import CSV file from fixed directory 1
Connection files and pivot tables 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Import Multiple CSV Files from Same Folder into Open Workbook 5
Excel & MS Query caused compile errors 14

Top