Import/Append a table with different field names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure if this is possible but someone out there may know a way. I
have about 50 access databases that all have the same field names such as;

FirstName LastName Address City State

I need to import or append or somehow transfer the data that is in the 50
other databases into a single access database that has different field names
but same type of data. Different field names such as;

FrstNm LstNm Addr Cty St

Does anyone know how I can do this maybe with a macro. Any and all
suggestions will be greatly appreciated. If it were just one or two instead
of 50, I would just manually make the changes but 50 may also turn out to be
100.
Please help if you know of a way.
Many Thanks,
Ms. Gayle
 
Via VBA code, you could use DoCmd.TransferDatabase action to link to the
table in one database, and then run an append query to copy the data from
that linked table to the table in your "permanent" database. Then the code
would continue looping through the databases to do the same thing over and
over.
 
Back
Top