Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Unanswered: How to transfer a database from MS Access to MS SQL

    Hi all,
    How to transfer a database from MS Access to MS SQL? Is there some tools?

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    I believe there's an upsizing tool but this is the wrong forum to post. You'll really want to post in the MS SQL forum rather than the Pervasive.SQL forum. This forum is for the Pervasive.SQL database not MS SQL.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Feb 2004
    Posts
    78

    Re: How to transfer a database from MS Access to MS SQL

    Originally posted by aboakai
    Hi all,
    How to transfer a database from MS Access to MS SQL? Is there some tools?
    Just use the DTS Import tool in the Sql Server Enterprise Manager. In the source section choose MS Access and locate the mdb file.

Posting Permissions

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