05-17-2015 03:55 PM
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?
05-21-2015 09:06 AM
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.
06-09-2015 07:23 AM
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