11-01-2008 09:02 AM
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?
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?
11-01-2008 09:16 AM
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.