Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2005
    Posts
    115

    Unanswered: Access -export-> MS SQL 2005

    how can i export all the content of an access database into a MS SQL 2005 database, with of course similar tables ?

    thank you

  2. #2
    Join Date
    Dec 2005
    Location
    Texas
    Posts
    100
    I don't know about SQL 2005 since I've never used it, but in SQL 2000 you can simply import an Access database in its entirety using a single DTS package. Does that help?

  3. #3
    Join Date
    Jun 2005
    Posts
    115
    ok i try !

    thank you

  4. #4
    Join Date
    Feb 2006
    Location
    NJ
    Posts
    3
    Another way would be to use the Upsizing Wizard within Access. You can find it in the 'Tools>Database Utilities' menu within Access.

  5. #5
    Join Date
    Jun 2005
    Posts
    115
    ok thank's a lot

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Quentin

    The upsizing wizard is a nice utility (and I would use it too) but remember to go through the migrated tables and check that the wizard has chosen the most appropriate (read correct) data types as there is not a simple 1 to 1 mapping from JET to SQL Server.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Jun 2005
    Posts
    115
    i have to migrate t SQL in the next 2 weeks a big and full access database :-)

    thanks to everyboy

Posting Permissions

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