Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Importing ODBC Data .. anywhere??

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refreshing ODBC data on Protected Sheets AndrewC Excel Discussion (Misc queries) 0 November 10th 09 05:33 AM
Recent ODBC problem linking to CSV data Safety in numbers Excel Discussion (Misc queries) 2 September 4th 06 05:05 PM
change odbc data source jenn Excel Worksheet Functions 0 January 20th 06 12:12 AM
ODBC data insert to Oracle renee New Users to Excel 0 October 18th 05 08:37 PM
ODBC Driver/Import Data Andy Excel Discussion (Misc queries) 0 May 12th 05 09:10 PM


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"