
How to Link an Access Database with SQL Server
Question: I want to extract/insert data by linking one Access table with a SQL server table through VB code. So far, I am not able to to it (using ADO 2.1). Can I write a query in VB similar to: dbo_retired_hcpc – Sql Server TableTPARTBHCPCSecondFinder – Access tableselect * from