Merge excel files with different column headings

[rob_ford16]

Hello,

I'm new here so please forgive any naivety. I have about 100 exce
workbooks that contain essentially the same types of data. Each fil
details plant collections of certain people and each plant
corresponding habitat, date collected, locality, county, state, specie
etc. Yet they have many different column names for the same thing
(I.E., date collected = collection date = Col_date = coll_date)

How could I go about combining all of these files into one, whil
keeping the columns matched up? I want the data in File #1 under th
column heading "Date Collected", to be under the same column as the dat
from File #2 with a column heading of say, coll_date.

I've imported all of these into Access as separate tables and though
maybe I could use SQL to do something but I just am not sure what to do


Besides copying and pasting for hours on end, I have no real solution t
this problem.

Any help is much appreciated!

I've attached a zip file with an example of workbooks I need to combine

+-------------------------------------------------------------------
|Filename: Example Records.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=400
+-------------------------------------------------------------------

 

[GS]

Have you considered implementing a 'data map' where you match the
headings from each file to your desired data fields?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion