Merge 8 tables with like fields into a single table

[GraeagleBill]

How does one merge the 8 tables pictured into tblAllSheets? UNION? Some sort of multiple APPENDS?

[June7]

A UNION can merge them into a single dataset. Then if you want to, can create a table from that dataset.

Do these tables have related child tables?

[GraeagleBill]

Do these tables have related child tables?

No, they're all the same structure. I just need to get all the records together in a single table. I've never seen a problem quite like this and was hoping Access had some friendly way of merging the tables.

[June7]

Well, do a UNION query or run 8 INSERT INTO SELECT actions to populate a table or simply copy/paste records from one table to another.

Name is a reserved word. Advise not to use reserved words as names. Also advise not to use spaces in naming convention.

[GraeagleBill]

I inherited all this junk originally as individual WorkSheets in an Excel file. I tried the copy/paste to begin with, but the paste didn't work at all. Maybe the appearance of the reserved word interfered? I'll take some time in the AM to clean up the field names and have another go with Copy/Paste. I have another collection of this junk coming later in the week, so hopefully I'll learn how to better deal with this issue before then.
Thanks June,
Bill

[Micron]

If you're going to paste from a sheet to Access table, you must use paste append, not paste. Sometimes doesn't work either.

[GraeagleBill]

So, I do what, create a new table with matching fields and append paste the data sheet view of this goofy looking query? (goofy looking or not, it gets me what I need.)

SELECT * FROM A2 
UNION SELECT * FROM A3 
UNION SELECT * FROM A5 
UNION SELECT * FROM B1
UNION SELECT * FROM B2
UNION SELECT * FROM B3
UNION SELECT * FROM B4
UNION SELECT * FROM B6;

Learn something new every day. Paste Append worked like a champ!
Thanks,
Bill

[Micron]

Yer welcome. Mark this one as solved?

[GraeagleBill]

Hummm! I thought I did and I see it marked as such.

[Micron]

I must have been looking at an outdated search results list!