I am running Access '97. I want to copy all records from a temporary table called "Import Interlink Despatch" into a log table called "Import Interlink Log". There are only 4 fields to copy and I have checked the field names.
It's part of a module - and i don't want to use / call a append query. I
want to use the "Insert Into" statement. Just cannot get this to work! Here is my code:
Dim MyWorkspace As Workspace, MyDatabase As Database,
Set MyWorkspace = DBEngine.Workspaces(0)
Set MyDatabase = MyWorkspace.Databases(0)
I have had the feeling that my connection string may be incorrect - but this has worked with every other module I have run and I have never experienced any problems. Also, the Delete SQL statement that precedes the Insert Into statement runs fine.