Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act17 only Imports 1 line from Excel Spreadsheet - HELP

New Member
Posts: 1
Country: Canada

Act17 only Imports 1 line from Excel Spreadsheet - HELP

No matter what I do, when I import a large spreadsheet from Excel, ACT17 tells me alomst 3600 records import, but only the first line shows up in the ACT records.  What am I missing?

Copper Super Contributor
Posts: 22
Country: United_Kingdom

Re: Act17 only Imports 1 line from Excel Spreadsheet - HELP

Hello

Do you have any blank columns or rows in the excel sheet?

I've seen this before when there is. Also remove any formatting. i.e bold, underlines etc. Failing that sometimes there is hidden issues so best practice is to highlight all the data and copy it into a new excel sheet. Don't copy by highlighting the columns (A,B,C etc)  just the actual data.

 

This should do it.

 

Just a thought when you Import are you selecting auto or custom import? Always go for custom even though it says automatic (recomended) so you can check and map the fields and see what data will be imported.

Robert Hupston
Act! Certified Consultant
Web: http://softext.co.uk
Email: rob@softext.co.uk
Tel: 0121 323 2304
New Member
Posts: 5
Country: USA

Re: Act17 only Imports 1 line from Excel Spreadsheet - HELP

Be certain as well that there are no extra commas or such in the contact fields as that will cause it to abort
Nickel Elite Contributor
Posts: 934
Country: USA

Re: Act17 only Imports 1 line from Excel Spreadsheet - HELP

You did not indicate what exact version of ACT!v17 you are using and is this the primary database or a remote databse that gets synced to the main db?  If using ACT!v17 Pro, you should prob be on service pak1 hot fix3?

Reference link to download center http://www.act.com/support/download-center/act-pro-v17/

cheers - FSB

 

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html