I have raised a question in
where I was helped in achieving a better understanding of Access and SQL Server.
Now the issue that I am facing can be summarized as follows:
I have an MS Access database called SurveyBMB.mdb that I need to link to SQL Server 2012 32bits as this database plays an intermediate role between 2 software one that is developed under VB6 that can communicate with the file thru SQL and an other software that is developed under VB.net that need SQL Server to communicate with the said file.
I was able to use Link Server option in SQL Server 2012 to attach this SurveyBMB.mdb successfully thru the provider
Microsoft Office 12.0 Access Database Engine OLE DB Provider.
My problem is the following:
In my VB6 program I now need to use ADO connection to communicate with the linked server SurveyBMB in SQL Server so I need to know what is the connection string and what is the correct SQL Syntax for the following SQL
INSERT INTO SurveyBMB.Survey SELECT * FROM `Survey` IN "C:\SURVEYTRACKING\Survey2
014.mdb" WHERE Survey.VESSEL = 'ABC 24/14' and Survey.[Date Arrival] = '11/7/2014' ORDER BY Item
obviously Survey is a table in the Access file "C:\SURVEYTRACKING\Survey2
SurveyBMB.Survey is a table in the linked Server file SurveyBMB.mdb
Any help in this issue is much appreciated.