Home » RDBMS Server » Server Utilities » Importing data from an Excel sheet/file
Importing data from an Excel sheet/file [message #74139] Sun, 19 September 2004 23:23 Go to next message
T. Sri Sai Krishna
Messages: 17
Registered: May 2002
Junior Member
Hi,

I have an MS Excel file containing several worksheets. I want to know how I can Import this data into tables in Oracle. Is there a tool to do this ?

Do I need to export the excel data into a text file and use Sql*Loader to upload the information ? Will exporting the individual excel sheet to tab delimited files help in this?

Does MS Excel provide a way to export data in comma delimited format?

Your help in this regard will be greatly valued.

Thanks in Advance,

SriSai

Report message to a moderator

Re: Importing data from an Excel sheet/file [message #74142 is a reply to message #74139] Mon, 20 September 2004 04:00 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
yes.
just save the excel file as CSV or tab delimited ones.
USE sql*loader to load data.

Report message to a moderator

Previous Topic: Importing dump files questions (urgent)
Next Topic: SQL LOADER Challenge
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 01:02:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.