Home » RDBMS Server » Server Utilities » Export excel data to oracle
Export excel data to oracle [message #69138] Tue, 06 November 2001 09:03 Go to next message
shalu
Messages: 7
Registered: November 2001
Junior Member
Hi I am trying to export data from an excel spreadsheet to my oracle database. I was thinking I could write a VBA in Excel to write it out as an importable SQL script. Do You think this may be right. Does anyone have a similar script that I can have a look at.
Thanks Shalu

----------------------------------------------------------------------

Report message to a moderator

Re: Export excel data to oracle [message #69139 is a reply to message #69138] Tue, 06 November 2001 09:07 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
save excel file in csv format and write control file to load data into Oracle DB using sqlloader

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Pro*c array insert
Next Topic: Importing the dump/export file with FULL=Y but except one particular schema
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 05:27:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.