OraFAQ Forum: Server Utilities » Import data into database from Excel spreadsheet

Home » RDBMS Server » Server Utilities » Import data into database from Excel spreadsheet

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import data into database from Excel spreadsheet [message #73808]

Thu, 15 July 2004 10:09

Raquel
Messages: 46
Registered: July 2003

Member

Is it possible to import data from an excel spreadsheet into a table? If so how?

Report message to a moderator

Re: Import data into database from Excel spreadsheet [message #73810 is a reply to message #73808]

Fri, 16 July 2004 16:16

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 21 04:57:44 CDT 2026