How to export an Excel file to an Oracle table ? [message #70692] |
Mon, 15 July 2002 06:41 |
noel
Messages: 14 Registered: January 2001
|
Junior Member |
|
|
Hello,
I'm trying to find a friendly way (user oriented) to create an Oracle table with datas coming an Excel file.
(I would like to avoid a first export to Notepad, then a load to Oracle using UTL_FILE package, but don't see any other solution at the moment !).
Thanks in advance.
|
|
|
|
|
Re: How to export an Excel file to an Oracle table ? [message #70762 is a reply to message #70692] |
Sun, 21 July 2002 20:11 |
sunil bhola
Messages: 58 Registered: July 2002
|
Member |
|
|
Create a Document/File in Excel => Save it in the default type “SAVE AS TYPE” in Excel format=> Open MS Access=> Get External Data => Import => Choose Microsoft Excel from the FILE OF TYPE => Choose the File which you want to Import=> Follow each steps of Import Spreadsheet Wizard => Must Check the box for FIRST ROW CONTAINS COLUMN HEADING=> After all click on FINISH => File => Save as/Export => select “TO AN EXTERNAL FILE OR DATABASE => select ODBC Database from SAVE AS TYPE => Type the new name of table if you want to do so => ok => select the DSN i.e. SUNIL from the box => ok => enter the PASSWORD of user =>ok
hope it will help you
|
|
|