you can connect to MS Access, using Microsoft.Jet.OLEDB.4.0 or MSDASQL.
[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb;Persist Security Info=False
[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Persist Security Info=False;Data Source=FromAccess
Now which is better for a linked server? You will find the answer to this in the following article brought to you by SSWUG.ORG. This is site where you subscribe, but you can register as a guest to view this article.
Microsoft Access 2003 Linked Server on SQL Server 2008 using the JET and MSDASQL Providers
No comments:
Post a Comment