How to Import Data from a Microsoft Access Database to SQL Server
Devin Manno 
November 15, 2013
Devin Manno November 15, 2013If you need to import data from a Microsoft Access database to SQL Server, one simple way is to setup the Access file as a Linked Server. You can add the linked server using the SQL Server Management Studio GUI, or through T-SQL commands. Run the sp_addlinkedserver procedure to add a Linked Server. Follow that Continue reading →