How TO join many tables into one in Access

Question

Hi,

I had a table with some 25000 records and 75 fields. For easier analysis i broke them down into 10 tables with 2500 records each. now i want to put them back together to form a single table. how do i write a query. i tried a select query like select * from (table1, table2.....) but i get error as query is too complex.

tksy

Answer 1

select * from tableA
union
...
select * from tableN

Answer 2

Explicitly select the field, to ensure a perfect match when you use UNION.

For example,

SELECT
    FirstName,
    Surname
FROM
    tblCustomer1

UNION

SELECT
    Name [Firstname],
    Surname
FROM
    tblCustomer2

Select the specific columns you want and make sure they are all named identically and contain the same data type.