Extracting excel file

m_siddu2000 · Post by **m_siddu2000** » Wed Sep 13, 2006 10:32 pm

How to extract the excel file and load into oracle database using parallel edition?

ray.wurlod · Post by **ray.wurlod** » Wed Sep 13, 2006 10:39 pm

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.

Xpert · Post by **Xpert** » Thu Sep 14, 2006 5:24 am

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.

Raftsman · Post by **Raftsman** » Fri Jun 15, 2007 7:03 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Jun 15, 2007 3:47 pm

If the server is Windows ODBC should be fine with it, so long as the DSN points to the correct location.