Adding an extension to tables

[skipnick]

I have around a hundred tables all with exactly the same format and headings that i would like to combine into one long table, but the copy-paste append data to table function doesnt do what i had hoped. How can I join my tables together? And is there an easy way to do all 100 at once?

[June7]

Why doesn't the copy/paste work? What happens?

You will probably need a new field in the final table that has a category value for each of the source tables.

Whether or not there is an easy way is a matter of perception. You can run 100 INSERT SELECT sql actions or you can write some code that will run them for you. A UNION query can combine tables but there is a limit of 50 tables in any query. You could write two UNION queries each having 50 tables and then maybe another UNION that combines the two queries. I've never tried that.

[skipnick]

I was trying it manually but after the first two are appended, the copy paste method just stops doing anything. New entries just aren't added. How can i construct a union query? I'm very new to access

[June7]

Review http://www.w3schools.com/sql/sql_union.asp