Results 1 to 2 of 2
  1. #1
    dba is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2011
    Posts
    1

    Export table from Oracle to Microsoft Access 2007

    Hi all,


    Periodically i need to export a table ('MyTable') from my Oracle 10g database to my Microsoft Access 2007 Database. 'MyTable' table's can change dynamically and the export process have to support it.

    For example, initially 'MyTable' table can have a column named 'COL1'. When exporting i need to create the same 'MyTable' table in a Microsoft Access database (this Access database may be a empty access database or if possible i would like to create dinamycally). The next time 'MyTable' can be modified and it can have a new column named 'COL2'. When i export the table 'MyTable' i need to export it with the new structure and content to Microsoft Access Database.

    If the structure of original table 'MyTables' was "static" i would make a connection through OLEDB or ODBC (through heterogeneus services configuration) having a predefined Microsoft Access Database, but to being table 'MyTable' dinamic this solution is not valid for me.

    Could anyone tell me how could i export the table 'MyTable' to Microsoft Access Database 2007?

    Many thanks in advance

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Feb 2009
    Posts
    235
    Create a ODBC link to the oracle database table1 on a new access mdb.

    Then create a make table query to that linked table1 to create a new table2.in the access mdb file.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 02-08-2011, 02:34 PM
  2. Microsoft Access 2007 - 2010 Compatibility
    By AccessFreak in forum Forms
    Replies: 4
    Last Post: 01-05-2011, 07:57 PM
  3. Replies: 3
    Last Post: 06-22-2010, 07:49 AM
  4. Developer Option in Microsoft Access 2007.?
    By aligahk06 in forum Forms
    Replies: 1
    Last Post: 04-23-2010, 01:44 PM
  5. microsoft access 2007 video tutorials
    By jamesdean in forum Access
    Replies: 0
    Last Post: 06-08-2007, 08:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums