Page 1 of 1
Mulriple excel sheets, multiple table
Posted: Tue Aug 11, 2009 1:46 am
by laiko
Our user have to drop 5 excel files. Each file loads to its corresponding table. Now, they wanted to have one excel file with 5 different sheets instead for their ease of maintenance. How is it possible (without manual intervention) that I load each sheet to a different table? Or any workaround you can think of? Thank you.
Posted: Tue Aug 11, 2009 1:54 am
by ArndW
This is an ODBC definition issue, i.e. how do you tell an ODBC connection to go to a specific Excel tab. As far as I know, it cannot be done.
Posted: Tue Aug 11, 2009 3:21 am
by DS_SUPPORT
Converting 5 sheets to 5 different CSV files ?
Posted: Tue Aug 11, 2009 4:26 pm
by ray.wurlod
Using ODBC each worksheet in a workbook is a separate (system) table. Your DSN points to the workbook and you can import table definitions and otherwise work with the individual worksheets as separate tables.
The ODBC driver has its own restrictions, mainly that the worksheet be in tabular format and first line must be (legal) column names.