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?