Linking an SQL Table to an Access Table

Eileen,

Yes.

Are you linking from Access to SQL Server, or from SQL Server to Access?

If it's case #1, you simply use ODBC and Access Linked Tables.

If it's case #2, you have to configure a Linked Server in SQL Server, to the
Access database you need. Once it's set up, you can query it, join to it,
etc.

James Hokes

"Eileen" <eilse_p@yahoo.com> wrote in message news:3dac3486$1@10.1.10.29...
>
> Question: Can I link an SQL TABLE to an Access table?
>
> Cheers,
> Eileen