Community
Showing results for 
Search instead for 
Do you mean 
Reply

Can't import database

New Member
Posts: 3
Country: USA

Can't import database

ACT Pro 2011 hot fix 6, excel 2007.  When trying to import a database in xlsx, xls, comma delimited or tab delimited, only the first entry is imported.  Been using ACT for years and this is the first time this has happened.  Any suggestions?  Thank you.

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Can't import database

Hello John,
Welcome to the ACT! Community!

You'll want to test some variations to help isolate the issue:
- Attempt import into Demo database (or create new database)
- Open file using Excel and remove any blank columns/rows
- Ensure all data is listed in different rows/columns in Excel (It may be attempting to import as a single record)
- Disable Duplicate Checking under Tools > Preferences > then attempt import
Greg Martin
Sage
New Member
Posts: 3
Country: USA

Re: Can't import database

Thank you Greg.  Disabling the duplicate checking worked.   

John

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Can't import database

Glad to hear it worked! Thank you for posting the update.
Greg Martin
Sage