Thank you Golom. I tried your code and I got an error that indicated that I needed another '. I added one at the end of the code : ..... gTableName & "'))",-1
and it worked great. Thank you so much.
TeddyTerrier
I need to append data from one table (Transfer) to 1500 different tables without keying in the table names or the criteria for the query to use. I have been able to get the data to go to the correct table, but the I am having to type in the criteria for the filter. Here is what I have done...
I need to append some data to about 1500 different tables in Access. I would like to append the data to the different tables without having to specify the destination table for each table. I have a field in the original table (table that I am getting the appending data from) that has the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.