Last post Feb 26, 2019 05:09 PM by limno
Feb 26, 2019 03:27 PM|slimbunny|LINK
Please help me fix my string, I need to copy data from MS Access Database table to SQL Table. The path is correct but I am not sure what I get the error message. Please share your expertise. Thank you...
Select * INTO DestinationTable.Batename
Incorrect syntax near 'D:\Temp\FolderName\database123.mdb.Batemane'
Feb 26, 2019 03:49 PM|PatriceSc|LINK
According to https://support.office.com/en-us/article/from-clause-b2cf2c01-80d9-4210-9d7a-5f1d38dcbfbb?ui=en-US&rs=en-US&ad=US it
might be rather :
Select * INTO DestinationTable.Batename FROM Batemane IN 'D:\Temp\FolderName\database123.mdb'
But anyway this is is something particular to Access that won't run in SQL Server. Instead you could try https://sqljana.wordpress.com/2016/10/12/setup-a-linked-server-to-ms-access-from-sql-server-beat-the-errors/
Feb 26, 2019 04:45 PM|slimbunny|LINK
Thank you PatriceSc, the codes did not work and the Linked Server to MS Access from SQL server is an issue. My linked server does not list MS Access as an option so I have to install that first.
Feb 26, 2019 05:09 PM|limno|LINK
Try from Access to point to your SQL Server.