OraFAQ Forum: Server Utilities » Load Access database into Oracle 8i

Home » RDBMS Server » Server Utilities » Load Access database into Oracle 8i

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

Load Access database into Oracle 8i [message #73110]

Tue, 03 February 2004 20:33

SJC
Messages: 11
Registered: December 2003

Junior Member

Hi,

Can anyone tell me how to load MS Access (*.mdb) database into Oracle 8i. Any solution using SQL* Loader,SQL* net or ODBC,ADO etc. are welcome

Thanks and Regards
Subhajyoti Chanda

Report message to a moderator

Re: Load Access database into Oracle 8i [message #73112 is a reply to message #73110]

Wed, 04 February 2004 01:46

Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA

Senior Member

You can export each table from MS Access to a text file, then load each text file into an Oracle table using SQL*Loader. That's how I used to it.

Report message to a moderator

Re: Load Access database into Oracle 8i [message #73423 is a reply to message #73110]

Fri, 23 April 2004 06:38

sharon triplett
Messages: 1
Registered: April 2004

Junior Member

Need to load Access program to my coumpter thank you mrs sharon triplett

Report message to a moderator

Re: Load Access database into Oracle 8i [message #73424 is a reply to message #73423]

Fri, 23 April 2004 06:43

shaon triplett
Messages: 1
Registered: April 2004

Junior Member

lOAD ACCESS TO MY COUMPTER iF IT CAN BE DONE pLEASE NEED IT FOR MY CLASSES NEXT SEMTER

Report message to a moderator

Previous Topic:	List of OS and Oracle Users
Next Topic:	If system down

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 13:15:52 CDT 2024