skumpy
February 23rd, 2000, 12:19 PM
I have a SQL db. I have copies of certain tables sitting on the local drive for use if the network goes down and/or if the user is offsite. I need to synchronize these tables when the user opts for an update. I have this all done with the tables where it is just certain files; however, for tables that need to be entirely copied, I tried using the INSERT INTO with the external database option... here's the code:
NetCMD.CommandText = "INSERT INTO tblClean IN template.mdb" & _
" SELECT * FROM tblClean;"
NetCMD.Execute
In this example, the netcmd connection is to the SQL Server and template.mdb resides on the user's hard drive. When I try to run this code I get an error stating "there is an error near the IN statement". Anyone know how to do this?
NetCMD.CommandText = "INSERT INTO tblClean IN template.mdb" & _
" SELECT * FROM tblClean;"
NetCMD.Execute
In this example, the netcmd connection is to the SQL Server and template.mdb resides on the user's hard drive. When I try to run this code I get an error stating "there is an error near the IN statement". Anyone know how to do this?