How can i Append to Table using table Variable name

Hello everyone,

I want to import data on a monthly basis into tables, but I want to be able to use the same import buttons each month and pass the data into the relevant monthly table.

My Steps - Set Reporting Month variable (which sets the Table name Variable), choose the file to import, import this data to a holding table, append the data to the relevant monthly table.

I have this working up to the APPEND part. I have variables set up for the Table Objects, but I am having a problem using this variable in the APPEND SQL. I don't know how to do this!!!

Any help appreciated

Champs,

Yes we can use a variable for a table name in an append query

Try this code

Please Login or Register  to view this content.