Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
Merge two files based on one column | Excel Discussion (Misc queries) | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
column headings for merge | Excel Discussion (Misc queries) | |||
Can I use Merge Fields in Excel Headings? | Setting up and Configuration of Excel |