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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Merging cells in Excel table 7
How to export table from outlook into ms access table? 0
mail merge problem 2
New to Access please. I created all the tables I need how to merg 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
MERGE TWO TABLES IN ACCESS 4
merging tables 2

Back
Top