12/22/2010 ExportFinished, click to view file.
I created an export template which is supposed to append data to an existing table in an Access database (.mdb format). The automation task runs and creates a new database with a date extension then I get the following error…
12/22/2010 ERROR [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTOstatement.
12/22/2010 Endwhile loop
Any ideas on how to fix this? Can the append feature only be used with .accdb formats?