How can I merge tables in access to make one big table

  • Thread starter Thread starter Judy K
  • Start date Start date
You shouldn't.

Separate entities of data should be kept in separate tables. If you just
need something for display or reporting purposes, you can create a query
that merges data from many tables.

Why do you think you need to merge all your data into one big table?

Perhaps someone can advise you of the proper way to accomplish
whatever it is you want to do.
 
How can I merge seperate tables in access into one big table
Click to expand...

With a Query - either a join query to join the tables side by side, or an
Append query to add the records from one table as new records in the other.

For a more detailed answer please post a more detailed question.
 
Back
Top