|
Re: Import Excel into Oracle [message #97512 is a reply to message #97509] |
Tue, 02 July 2002 07:43 |
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.
|
|
|
|
|