Home » RDBMS Server » Server Utilities » Covert Data from Text File to Oracle8i
Covert Data from Text File to Oracle8i [message #72714] Wed, 01 October 2003 04:16 Go to next message
sudhanshu
Messages: 5
Registered: April 2002
Junior Member
My basic purpose is to convert the Access Table in to Oracle Table. I could use Oracle Work Bench. But My requirement is to export the table from MS Access XP to Oracle8i on regular basis.
Please usggest me how to convert the dat either from Text File or CSV or ............

Sudhanshu

Report message to a moderator

Re: Covert Data from Text File to Oracle8i [message #72717 is a reply to message #72714] Wed, 01 October 2003 06:29 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
create the csv from access.
use sql*loader to read the csv file and load into oracle table.
but i beleive, this is not the efficeint way.

Report message to a moderator

Previous Topic: help!i am using exp and get error infomation"EXP-00008: ORACLE error 6552 encountered"
Next Topic: sqlldr problems please help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 11:18:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.