Community
Showing results for 
Search instead for 
Do you mean 
Reply

Best way to import data from MS Access database?

New Member
Posts: 1
Country: USA

Best way to import data from MS Access database?

Is there a way to move data from a custom Microsoft Access database to Act 2010 Premium?

 

There are one-to -many relationships, such as a notes table that links to the customer table and may contain many notes for a single contact.

 

Thanks in advance.

Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Best way to import data from MS Access database?

I've used OakMerge to move data from Access tables to ACT! 2010 tables however retaining relationships might be hard.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Best way to import data from MS Access database?

Nickel Elite Contributor
Posts: 508
Country: USA

Re: Best way to import data from MS Access database?

I've never used it, but I've heard itImport is good.  Also, I *have* used TopLine Designer, which is basically a table AddOn for ACT!   You could use this for what you need as well, but the Notes wouldn't go into "ACT! Notes", it'd be a notes table - but you would retain the relationships.

Richard Brust
ACT! Certified Consultant
richard@rbrDataSolutions.com