Copying table data to other table

  • Thread starter Thread starter Mark F.
  • Start date Start date
M

Mark F.

I have an Access 2000 database that contains six tables. They all
contain the same fields (Object, Name, Desc, CodeNo). I want to copy all
the data from each table into one big table in another database file
(mdb). Is that possible?

Thanks,
Mark
 
With Append Queries.

Design Append Queries for each of the six tables keeping the target table as
the same for all of them.
 
I wasn't quite sure how to create an append query. Once I knew what to
do, I found it in the help files. Worked perfectly and saved me a lot of
work. Thanks!

Mark
 

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

Merging table data 1
VBA - retrieve data on last create named range from previous inserted named range 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Copy data from one databse tabel to other database table 1
Coverting linked tables into local tables 2
Access Table match or lookup or other method 0
Relink Tables From Multiple Sources? 2
Insert Values Of External Table Into Current Data Table 0

Back
Top