Retrieve MS-ACCESS TABLE FROM SQL SERVER

SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\db1.mdb';'Admin';, TEST)




http://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/