I have several Access tables, 30 or so, that should be linked to each other.
I have a diagram on paper that shows how the tables link to each other.
When I opened up the Access files to start working on this project, I
discovered they were in separate files. How is this? Is there a way to
link a table in one Access file to a table in another Access file?
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?