After the file linking is accomplished, I need to transfer about 30,000 rows
from these tables into one Access table.

Right now I'm using VB6/DAO to query the information and plug it into the
new table one row at a time.  With 30,000 rows, this method will take more
than a few hours.

By the way, the new table will also have different column names.  So the
info will have to get copied to a table with a different column names or
after the table is populated, the column names will have to be changed;
which ever is easiest.

Is this table linking possible and could someone suggest a method to speed
up this process?

Thanks
Sally

I'm not sure I understand your question but I'll give it shot.  If you open
a brand new mdb file you can go to the File tab on the tool bar.  One of the
option is "Get External Data."   A sub menu pops up with two options --
Import , Link Tables.  You want to select Link Tables.  At that point you
given a file dialog that allows you navigate the directories you need to
select the mdb's you want to link to.  Once you select the mdb, a dialog box
will come up which will show you which tables you want to link to your new
data base.  You select the tables you want to link to and press OK.

When you have all your tables linked in your new data base, you can select
the query tab and write a Make Table query for the new table you want to
create.  Another way is to create the table and field definitions and then
write an Append query.  Either way will work.

Good Luck.
Eric