Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Exporting MS Access to MS SQL

    I have an MS Access database, which I want to export as an MS SQL Server database. How is this done? I have Microsoft Access XP.

    I notice that the "Export" feature doesn't work unless you select a table. Does that mean that I cannot export the entire database in one operation, but will need to export each table individually? What about the relationship between tables?

    Also, I was told that Access XP has an "Export to SQL Server" feature. I didn't see that.

    Thank you for your help.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Methinks you want the upsizing wizard for this job!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts