|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Linking Microsft Access in SqlIs 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 Bob,
Sure - see: sp_addlinkedserver http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp and sp_addlinkedsrvlogin http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_6e26.asp HTH Jerry Show quote "bob at zachys" <bobatzac***@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  |
|||||||||||||||||||||||
Other interesting topics