Results 1 to 2 of 2
  1. #1
    Alan is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    1

    Import a .sql file?

    I have exported numerous statements (tables, inserts and constraints) from an Oracle 10g database into a .sql file. Is there anyway for me to import this into Access 2007 and retain all relationships etc...

    I have googled this but not found a satisfactory response. If it can't be done, is there any other somewhat short method?

    Thank you so much for the help.

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    Can you use odbc to connect with Oracle?
    Then Access can easily connect with this odbc to import data into it.

    See the following link whether it helps.
    http://www.databasejournal.com/featu...-and-Excel.htm

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

Similar Threads

  1. Replies: 0
    Last Post: 04-29-2009, 04:27 PM
  2. Upload file inside .mdb database file
    By havish in forum Access
    Replies: 0
    Last Post: 07-30-2008, 07:35 AM
  3. Possible to export *.mdb file to *.exe file?
    By slpuiwan in forum Import/Export Data
    Replies: 1
    Last Post: 12-16-2007, 06:52 PM
  4. How do you export a file with a unique file name
    By Budman42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-15-2006, 06:10 PM
  5. CSV File Import
    By compasst in forum Import/Export Data
    Replies: 3
    Last Post: 03-31-2006, 09:37 AM

Tags for this Thread

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