Home » Infrastructure » Unix » Import Excel into Oracle
Import Excel into Oracle [message #97509] Tue, 02 July 2002 06:30 Go to next message
Mickael
Messages: 1
Registered: July 2002
Junior Member
How can I import a .XLS Excel file into Oracle using SQL or another mean ?

Thanks in advance!
Re: Import Excel into Oracle [message #97512 is a reply to message #97509] Tue, 02 July 2002 07:43 Go to previous messageGo to next message
GK
Messages: 22
Registered: January 2001
Junior Member
You can do it using ASP.

1. You'll need to write a HTML form to upload the XLS file to a temporary folder on your ASP server.
2. Then you'll need to open a file-based DSN with the XLS file from within the ASP program... this will give you access to the data in the file.
3. Finally, your ASP program can load all that data read from the XLS file into Oracle.

You can find the details for each of these steps for ASP on several websites on the Net.
Re: Import Excel into Oracle [message #97592 is a reply to message #97509] Thu, 29 August 2002 18:57 Go to previous messageGo to next message
Mukilan
Messages: 1
Registered: August 2002
Junior Member
1. I want to import excel data into oracle varray object.
2. I also want to know how to get oracle data into excel sheet.
Re: Import Excel into Oracle [message #97611 is a reply to message #97509] Tue, 10 September 2002 14:11 Go to previous message
Larry
Messages: 11
Registered: September 2002
Junior Member
I'm currently trying to do this same thing. Have you received any responses yet??
Previous Topic: Open Files Error
Next Topic: Oracle for Solaris x86
Goto Forum:
  


Current Time: Tue Apr 16 13:13:20 CDT 2024