Home » SQL & PL/SQL » SQL & PL/SQL » How to export objects from Access 2003 to oracle 11g ? (access 2003 , Oracle 11g , window XP SP2)
icon5.gif  How to export objects from Access 2003 to oracle 11g ? [message #302109] Sat, 23 February 2008 11:46 Go to next message
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 20893
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.
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 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
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.
icon1.gif  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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
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
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 Go to previous message
Littlefoot
Messages: 20893
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.
Previous Topic: need help in writing pl/sql script
Next Topic: Disabling procedures and triggers
Goto Forum:
  


Current Time: Mon Dec 05 07:08:30 CST 2016

Total time taken to generate the page: 0.24162 seconds