Extracting excel file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Tue Aug 01, 2006 1:37 am
- Location: Hyderabad
Extracting excel file
How to extract the excel file and load into oracle database using parallel edition?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
Provided that the worksheets have a tabular form only, and with column headings, you can use the ODBC Enterprise stage via the Microsoft ODBC driver for Excel.
Otherwise you can pre-process the worksheet(s) to get them dumped into a file format, for example CSV. This limits you to sequential mode execution.
Provided that the worksheets have a tabular form only, and with column headings, you can use the ODBC Enterprise stage via the Microsoft ODBC driver for Excel.
Otherwise you can pre-process the worksheet(s) to get them dumped into a file format, for example CSV. This limits you to sequential mode execution.
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.
If the Excel file resides on your desktop and DS reside on a server, can I use ODBC to access the file on my desktop or do I need to FTP the file to the server.
I looked at ODBC stage and when it request Source in the properties field, is this where you enter the path and filename.
Thanks
I looked at ODBC stage and when it request Source in the properties field, is this where you enter the path and filename.
Thanks
Jim Stewart
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: