Community
Showing results for 
Search instead for 
Do you mean 
Reply

Trouble importing an excel file - please help!

Accepted Solution Solved
New Member
Posts: 3
Country: United_Kingdom
Accepted Solution

Trouble importing an excel file - please help!

Hello,

 

I am using Sage ACT! Premium 2011 Version 13.1.111.0. I am trying to import (custom import) an excel file of around 900 contacts with addresses, email and phone numbers. I can go all the way through to the progress bar where I have the option to merge contacts, I merge around 50 of these and then I get this error message:

 

'Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediatley.

 

Object reference not set to an instance of an object'

 

Regardless of what I select, ACT just crashes without finishing the import.

 

Any suggestions?? I really don't want to have to type out 900 contacts individually!


Accepted Solutions
Solution
Accepted by gmartin (Platinum Super Contributor)
‎09-25-2015 03:20 AM
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Trouble importing an excel file - please help!

Hello SWilkinson05,

Welcome to the Sage ACT! Online Community!

 

It may be a memory/resources issue, I would try breaking the import file into several files (3 or 4) and import the smaller lists.

Greg Martin
Sage

View solution in original post


All Replies
New Member
Posts: 3
Country: United_Kingdom

Re: Trouble importing an excel file - please help!

anyone able to help?? Smiley Happy

Solution
Accepted by gmartin (Platinum Super Contributor)
‎09-25-2015 03:20 AM
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Trouble importing an excel file - please help!

Hello SWilkinson05,

Welcome to the Sage ACT! Online Community!

 

It may be a memory/resources issue, I would try breaking the import file into several files (3 or 4) and import the smaller lists.

Greg Martin
Sage
New Member
Posts: 3
Country: United_Kingdom

Re: Trouble importing an excel file - please help!

Thanks Greg that worked!

 

Sarah

New Member
Posts: 22
Country: USA

Re: Trouble importing an excel file - please help!

Here with ACT 2012, it's not a memory issue.. it's 2 lines in excel for god sakes! Haven't been able to have import work for a week in a row without having to try 100 different tricks to it.

It doesnt run to any errors but nothing gets imported. We have been using ACT for past 10 years if not more..

Thanks.