Linked Server to MS Access from SQL Server
Step 1
install AccessDatabaseEngine.exe
[ Ссылка ]
Step 2
Server Objects -- Linked Servers -- New Linked Server
Name : Test
Provider : Microsoft office 12.0 access database engine Ole DB
Product Name: MS2003 any Name
Data Source: D:\Test.mdb Path File Access

свернуть