ACCESS 2003 TO SQL SERVER 2008

  • I have been working with Access 2003 till now but want to move into SQL Server 2008.

    Do you have any books that will help me in this transition Eg. Access 2003 to SQL Server 2008.

    As most of the books i found in amazon was about "access 2000 to SQL Server 2000" which is quite old version.

    Any idea pls.

    Reg

  • messagetosiva (4/9/2010)


    I have been working with Access 2003 till now but want to move into SQL Server 2008.

    Do you have any books that will help me in this transition Eg. Access 2003 to SQL Server 2008.

    As most of the books i found in amazon was about "access 2000 to SQL Server 2000" which is quite old version.

    Any idea pls.

    Reg

    Hi,

    You can try to use Linked Server or OpenRowSet.

    Regards,

    Eko Indriyawan

  • This should help you transistion your MS Access to SQL Database

    Hope this helps...

    Koncentrix

  • Hi

    i'm assuming you want to transfer your Access database to a SQL Server database. If so, try the "Upsizing Wizard" in MS Access 2003

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

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