Post reply

How to import MS Access database into SQL Server 2005

  • May 23, 2007 at 9:45 am

    #119090

    Hello,

    I have a database MS access: test.mdb.

    Is it possible to attach to SQL SERVER 2005, or any other solution ?

     

    Thank

  • May 24, 2007 at 1:09 am

    #708547

    Are you just transferring the data or the whole access application.

  • May 24, 2007 at 1:13 am

    #708549

    I need to transfer all the application:

    structure and data.

    How to do it?

    Thank

  • May 24, 2007 at 4:39 am

    #708577

    For data create a new table on you SQL 2005. Right click, import, choose MS Access and follow the dialog.

  • May 24, 2007 at 5:48 am

    #708588

    within access you can do the database upgrade wizard.

    from within sql you can do an import data (and select all the objects you want)

     

  • May 24, 2007 at 6:46 am

    #708604

    Hello,

    thank, from SQL Server I know that I can use SSIS, but I loose FK.

    So I try to start database upgrade wizard (I never used), where i find it?

    Thank 

  • May 25, 2007 at 8:07 am

    #708966

    You can also use SQL data import export feature. Just create a new database (in which you want to import your access file) with options you like; default would be ok. Now after sql server is done creating the database ... right click and All Tasks > Import data and go on with standard eay to use steps ... remember to choose transfer objects withd data when prompt. In case of any issues give us a post back .

    I hope it works for you.

    FP

    True Love is Like A Ghost. Everyone Talks About It & Nobody have seen it.

  • May 25, 2007 at 9:54 am

    #709020

    Thank to everybody

  • May 25, 2007 at 2:32 pm

    #709095

    Useful tool for everybody:

    http://www.microsoft.com/sql/solutions/migration/access/default.mspx

    from Access forum

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply