Hi All
I need to read an excel file using odbc.
Easy. The problem is that every month the excel file is in a different folder. Setting up the odbc is easy pointing to a file that will stay in one place.
The work around will be to copy the new file with a dsexecute to the original folder overwriting or something. Then use the file as the source and delete it after completion. Succesfull or not.
Is it possible to setup the odbc so that you point it to the subdirectory of choice if the original is pointing to the root of the sub directory.
I'm not expecting an answer other than the work around.
Maybe another way of doing it.
It is not possible to save the file as an csv file as it contains multiple worksheets and I need to access all the worksheets. It is easier to define he named range and increase it if needed.
All help will be appreciated.
p.s.
Is their a freeware utility to convert an xls file to csv file from command line.
ODBC connection to Excel files in different folder
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA