Ok I need to know if I am doing something incorrectly or if this just isn't possible:
I have my main DB running in SQL Server 2000 on my ISPs machine.
I need to copy the tables to an Access DB on my machine.
I can copy the data by opening two connections, creating a recordset and looping through
inserting to the access db. But this is very slow.
What I'd like to do is:
Drop the table in question from the local access db : No problems here
Connect to the remote SQL db : No problems here either
Then I would like to create a new table in the access db using the following select statement:
strSQL = "SELECT tblOld.* INTO NewTable IN 'D:\Path\OfflineDB.mdb' FROM tblOld;"
When I run the statement I get the following error:
Run-Time Error -2147217900 (80040e14):
Incorrect Syntax Near Keyword 'IN'
Is this just something that cannot be done in Access (2000)?