Home » SQL & PL/SQL » SQL & PL/SQL » Read spreadsheet into pl/sql
Read spreadsheet into pl/sql [message #243432] Thu, 07 June 2007 05:07 Go to next message
Messages: 1
Registered: June 2007
Location: New Jersey
Junior Member
I would like to take data from a excel spreadsheet into PL/SQl in some manner. Can I take it directly in somehow, or do I need to have the users input the data in something other than spreadsheet format??
Re: Read spreadsheet into pl/sql [message #243436 is a reply to message #243432] Thu, 07 June 2007 05:23 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
Save the excel file as a CSV and continue from there (external table, SQL*Loader, UTL_FILE, ...)

Previous Topic: How to release locks on a table
Next Topic: select Statement Required
Goto Forum:

Current Time: Thu Aug 17 16:41:57 CDT 2017

Total time taken to generate the page: 0.25256 seconds