Mulriple excel sheets, multiple table
Moderators: chulett, rschirm, roy
Mulriple excel sheets, multiple table
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.
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
The ODBC driver has its own restrictions, mainly that the worksheet be in tabular format and first line must be (legal) column names.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.