Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Location
    Fort Worth, TX
    Posts
    43

    Unanswered: Converting Access to SQL

    I am looking to convert my Access dbase to a SQL dbase and want to know if there is a way to import the table stucture and data easily without having to type alot of SQL to do it

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    What you want is the Microsoft Access Upgrade Wizard. If you can tell us which version of Microsoft Access you're using now and which version of Microsoft SQL Server you want to use in the future, we can probably find you exactly the right page.

    When you run the wizard, you:

    1) Pick an Access database file
    2) Pick a SQL Server and log into it
    3) Fill in a few details like the new SQL database name
    4) Let the Wizard do wizardly things!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    It works pretty well, too. Should do 90% or more of the work for you.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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