Page 1 of 1
Extracting excel file
Posted: Wed Sep 13, 2006 10:32 pm
by m_siddu2000
How to extract the excel file and load into oracle database using parallel edition?
Posted: Wed Sep 13, 2006 10:39 pm
by ray.wurlod
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.
Posted: Thu Sep 14, 2006 5:24 am
by Xpert
hi
you can use ODBC stage or Sequential file stage. If you are using sequential file, then first convert excel file to CSV format and then extract that CSV file.
Posted: Fri Jun 15, 2007 7:03 am
by Raftsman
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
Posted: Fri Jun 15, 2007 3:47 pm
by ray.wurlod
If the server is Windows ODBC should be fine with it, so long as the DSN points to the correct location.