From SQL Server, how can I link to a table inside an ACCESS(mdb) file?

Have you tried creating a linked server using the Jet OLEDB provider? Look
up linked server in BOL. The process is well documented.


joe.

[quoted text, click to view]

You don't link tables in SQL Server like you do in Access.
You create a link to the mdb and then execute queries using
which ever tables you need in the Access database. So you
are "linked" (but not in the same way as in Access) to the
entire mdb.
If you look up linked servers in books online, there is a
help topic in there for Access databases.

-Sue

On Fri, 21 Oct 2005 17:31:05 -0400, "Gary B" <no@spam.com>
[quoted text, click to view]