Append query - appending multiple tables quickly

[gotidude]

Hi Guys and Girls.

I have about 100 or so tables that I need to append back into one table

However all of these 100 tables all begin with the number 100 at the beggining. I know that you can append tables - but as far as I know you can only do one at a time. Is there any easy way to do this - for example writing a small SQL statement - saying select all tables that begin with 100* and then append into a master table

Alternatively are there any programs on the net that can do this (I just wrote a massive macro to import them from a text file in to access- not realising this problem would happen!)

Unfortunately each of the tables has the first row as the column heading too?

Any help would be much appreciated!!

Cuurently using Access 97 though.

 

[Pat Hartman]

You aren't likely to find something prebuilt so you[ll need to write the VBA yourself. You can use a code loop that reads through the directory and runs a TransferText method for each table. If you set the "has column headers" to true when you import the table, Access will interpret the first row as labels rather than data.