Merge excel files with different column headings
 

Hello,

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

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

I've imported all of these into Access as separate tables and thought 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 to this problem.

Any help is much appreciated! :)

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

Merge excel files with different column headings
 

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