How to join or concatenate two identical tables in one

[Anonymous]

Hello Everyone

I,m currently using MS Access to manage my data reports however due to amount of data it reach the maximum capacity(2GB), now I create other database with identical tables and fields in order to be able to join in the editor in one table.

My question is, how I can joint the identical tables in a single one?

[sunny_talwar]

May be like this

Table1:

LOAD ....

FROM ...;

Concatenate (Table1)

LOAD ...

FROM ...;