Community
Showing results for 
Search instead for 
Do you mean 
Reply

Merging multiple Excel files

Tuned Listener
Posts: 18
Country: United States

Merging multiple Excel files

I have several excel files all containing different information except for one piece of common information.  Is there a way to merge them all together into one Act database? 

For instance 

File #1 contains: ClientID, ClientName, Address, DOB

File #2 contains: ClientID, SpName, SpDOB

File #3 contains: ClientID, InsComp, Policy,PolDate,Type 

How can I merge all into one Act database?

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Merging multiple Excel files

Maybe combine them in Excel first?

 

Or, you can import the first into ACT! and then import the other two with itImport, which can merge into the database. You'd only need the basic edition.