ODBC connection to Excel files in different folder

hkotze · Post by **hkotze** » Thu Jun 12, 2003 4:44 am

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.

hkotze · Post by **hkotze** » Thu Jun 12, 2003 5:06 am

Hi

I found another way of doing it. I use the oledb stage and use the oledb for odbc. I then specify a connection string pointing to the folder containing the file. I created parameters and substitute the path with the parameter and it is working.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 19, 2003 5:11 am

Can you provide a URL for the Excel parser from CPAN?

tonystark622 · Post by **tonystark622** » Thu Jun 19, 2003 6:40 am

One of them is at:

Good Luck,
Tony