Home » RDBMS Server » Server Utilities » Import data into database from Excel spreadsheet
Import data into database from Excel spreadsheet [message #73808] Thu, 15 July 2004 10:09 Go to next message
Raquel
Messages: 46
Registered: July 2003
Member
Is it possible to import data from an excel spreadsheet into a table? If so how?
Re: Import data into database from Excel spreadsheet [message #73810 is a reply to message #73808] Fri, 16 July 2004 16:16 Go to previous message
gulshan
Messages: 19
Registered: January 2004
Junior Member
For importing the data from Excel u first create a text file from excel. To do this just save as text(tab delimited)(*.txt). It will create a text file with the tab space in each field. Then replace the tab with some delimiter such as (,).

After that use SQL Loader utility to import the file in Oracle.

I hope it will help u.

Regds

Gulshan
Previous Topic: Logging nocompress ORA-00922: missing or invalid option
Next Topic: hanging system
Goto Forum:
  


Current Time: Wed Dec 25 08:09:35 CST 2024