Home » SQL & PL/SQL » SQL & PL/SQL » How to Create Database Tables from Excel Spreadsheets
How to Create Database Tables from Excel Spreadsheets [message #197571] Wed, 11 October 2006 19:42 Go to next message
NewSQLdev
Messages: 1
Registered: October 2006
Junior Member
Hi,
I have recently started using PL/Sql and had the following question.
How do I load a list of data from an excel spreadsheet into an oracle database (in a new table)?

Thanks
Re: How to Create Database Tables from Excel Spreadsheets [message #197574 is a reply to message #197571] Wed, 11 October 2006 20:38 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Hi and welcome to OraFAQ.

You can use the Search tool on the forum to see if your question has been asked and answered in the past, thereby giving you your answer without having to wait.

This one has been answered many times, so I'm sure the search will bring up some useful results.

Ross Leishman
Re: How to Create Database Tables from Excel Spreadsheets [message #197659 is a reply to message #197571] Thu, 12 October 2006 03:54 Go to previous message
rikfair
Messages: 22
Registered: October 2006
Location: UK
Junior Member
Hi
These links may help.
This one shows how to create an external table based on a csv file.

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11210

This one shows how to automatically convert excel spreadsheets to csv format. Useful for automated routines

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11030
Previous Topic: Issue with NOT Exists when No Data
Next Topic: create a procedure
Goto Forum:
  


Current Time: Wed Dec 07 03:13:43 CST 2016

Total time taken to generate the page: 0.06541 seconds