Use Openrowset to select from Access into SQL Server

by Joe Hunter 9. May 2011 18:14

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\my_mdb.MDB';'ADMIN';'' , table_name)

Exporting data from SQL Server to Access using a Linked ServerSo I found out the hard way that to export data from SQL Server to Microsoft Access requires that th...How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008Reference is here Now...how to put this into a stored procedure? Getting the SQL server instance name using T-SQLHandy @@ function for getting the SQL server instance name using T-SQL: SELECT @@servername