471,573 Members | 1,738 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,573 software developers and data experts.

Combine tables from different .mdb files


Hello everybody.

Somebody has given me nine files with some data
for the years 1997, 1998, ... , 2005. They are 9 different
mdb files. Each one has many tables, forms, and other things.
But all of them have a table called EAL, with fields like year
(this year contains, for all the registers, the year corresponding
the one indicated by the file name), name, surname, country and much
more fields.

The person who has given me the files wants a new mdb file with
a table that should contain all the registers from all the 9 files, in
only that table, only one table, in a single mdb file, and without
the fields that we are not interested in.

How can I combine some fields of one table in every .mdb file
in a single table in a single .mdb file?

Thanks in advance,

S.
Jul 29 '06 #1
1 5172
Use a series of append queries on linked tables. there are other ways,
but since this is a one-off, just open the final mdb and attach the
tables and then create and run your append queries.

Jul 29 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Jamie Pittman via AccessMonster.com | last post: by
2 posts views Thread by Reidar Jorgensen | last post: by
4 posts views Thread by PZWU | last post: by
1 post views Thread by rdemyan via AccessMonster.com | last post: by
5 posts views Thread by Rodjk #613 | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by Vinnie | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.