Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2007
    Posts
    6

    Unanswered: How to Import access table into SQL express 2005 database?

    Can anyone help me import a ms access (97) table into a sql 2005 express database? The sql database already contains other tables but I would like to add some of my older access tables to this database without having to re-enter all the data. Please help! Thanks!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    SQL Server Management Studio for SQL Server 2005 (or Enterprise Manager for 2000) has a lovely Data Transformation Service (DTS) package builder.

    If you set up a table in your SQL database you can just map the data from access straight to the data source.

    DTS package -> look it up
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2007
    Posts
    6
    Do you know if this DTS package is present with management studio express? Because I am running sql 2005 express? I'm not having much luck finding it, sorry I'm pretty new with databases.

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313

  5. #5
    Join Date
    Feb 2007
    Posts
    6
    Thanks ! I will give that a try.

Posting Permissions

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