Mulriple excel sheets, multiple table

laiko · Post by **laiko** » Tue Aug 11, 2009 1:46 am

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.

ArndW · Post by **ArndW** » Tue Aug 11, 2009 1:54 am

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.

DS_SUPPORT · Post by **DS_SUPPORT** » Tue Aug 11, 2009 3:21 am

Converting 5 sheets to 5 different CSV files ?

ray.wurlod · Post by **ray.wurlod** » Tue Aug 11, 2009 4:26 pm

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.