Linking Microsft Access in Sql

Is it possible to link a Microsft Access table in Sql? What I am hoping to d
o
is to update an Access table using a DTS package. I need to join a SQL table
and a Access table and use the results to update anouther Access table. Is
this possible.
Thank you in advanceBob,
Sure - see:
sp_addlinkedserver
http://msdn.microsoft.com/library/d... />
a_8gqa.asp
and
sp_addlinkedsrvlogin
http://msdn.microsoft.com/library/d... />
a_6e26.asp
HTH
Jerry
"bob at zachys" <bobatzachys@.discussions.microsoft.com> wrote in message
news:8B29F201-D4C7-4981-8E6B-26CAA6C7E855@.microsoft.com...
> Is it possible to link a Microsft Access table in Sql? What I am hoping to
> do
> is to update an Access table using a DTS package. I need to join a SQL
> table
> and a Access table and use the results to update anouther Access table. Is
> this possible.
> Thank you in advance