SQL Server Express
Online get data from MS Acces to SQL Server
Question:
Hi All,
I have MS Access 97 database and SQL Server 2005 Express Edition (or SQL Server 2005 Developer Edition).
I want online get data from MS Access and upload to SQL Server.
Help me, which way I select ?
Regards
MSoft
Answer1:
From your SQL 2005 you can create a linked server and than get the objects you want,
you can also use SSIS to do that, but the must easy way to do is using SSMA(SQL Server Migration for Access ).
Please verify the link below:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
Regards...Emanuel Peixoto. Press Yes if the post is useful.