How to merge databases

[Guest]

I have multiple databases in Excel with similar data that
I need to pull into one large database.

The only way I know to combine the information is cut and
paste. Is there some way I can write a macro that will
look up the colum heading in database 2 and copy the data
under the heading into the same heading in database 1?

It sounds easy but I can't figure it out.

 

[Earl Kiosterud]

If you have Access, you can import the Excel data and easily combine them.
Useful if the tables are large and unwieldy for copy/paste. And the columns
don't have to be in the same place, as long as the headings are the same.
But otherwise may not save you much time. If this is a one-time project,
it's usually best to just do it manually and get it over with. The
important thing in any case is to carefully keep track of what you've done.
Put on some coffee and some music and get to it.