OraFAQ Forum: SQL & PL/SQL » How to export objects from Access 2003 to oracle 11g ?

Home » SQL & PL/SQL » SQL & PL/SQL » How to export objects from Access 2003 to oracle 11g ? (access 2003 , Oracle 11g , window XP SP2)

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

How to export objects from Access 2003 to oracle 11g ? [message #302109]

Sat, 23 February 2008 11:46

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

hello everybody

I have an access file contain a lot of tables and there some tables with a lot of columns.

so .... is there anyway to export the objects ( and data also if possible ) from Access 2003 to Oracle 11g ?

I'm waiting for the answer ....... and thanks in advance Very Happy

Report message to a moderator

Re: How to export objects from Access 2003 to oracle 11g ? [message #302120 is a reply to message #302109]

Sat, 23 February 2008 14:05

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

A straightforward way would be to export an Access table into a CSV file which may be loaded into an Oracle database via SQL*Loader or used as an external table.

A more sophisticated way would be to share data via ODBC.

Report message to a moderator

Re: How to export objects from Access 2003 to oracle 11g ? [message #302132 is a reply to message #302109]

Sat, 23 February 2008 17:46

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

I forget the specific steps or syntax, but you can create tables on Oracle, then define tables in access as linked tables (I think that is what they call them), these "link" tables would actually be hooks to your oracle tables, then insert from you access tables to your link tables.

Good luck.

Report message to a moderator

Re: How to export objects from Access 2003 to oracle 11g ? [message #303579 is a reply to message #302109]

Fri, 29 February 2008 21:09

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

I don't know how to export the tables in access 2003 to oracle 11g via SQL*Loader Sad

help please

Report message to a moderator

Re: How to export objects from Access 2003 to oracle 11g ? [message #303597 is a reply to message #303579]

Sat, 01 March 2008 00:14

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

To know how to "export an Access table into a CSV file" you may ask in a MS forum but I'm pretty sure there is an option in a menu.

To know how to "load this CSV file into Oracle", you may read Database Utilities, SQL*Loader

Regards
Michel

Report message to a moderator

Re: How to export objects from Access 2003 to oracle 11g ? [message #303616 is a reply to message #303579]

Sat, 01 March 2008 03:02

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Hany Freedom wrote on Sat, 01 March 2008 04:09

I don't know how to export the tables in access 2003 to oracle 11g via SQL*Loader

The first part is easy; right-click table in MS Access 2003, choose "Export". In "Save as Type" choose "Text files".

Michel pointed you to the documentation you'll need to study in order to successfully load previously exported text file into an Oracle database.

Report message to a moderator

Previous Topic:	need help in writing pl/sql script
Next Topic:	Disabling procedures and triggers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 06:55:13 CDT 2024