Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#53582 - 05/31/18 06:42 AM Excel file import - Skip blank cells with formulas

Registered: 08/17/05
Posts: 362
Loc: USA
Sage 2016, MS SQL

We have many import files to update Sage data. Once we query the data and edit it using formulas the file is saved. During the import Sage updates all the records correctly but after the last record their is an Excel formula but no data and Sage throws an error. I want to stop the error from occurring. Any ideas?
Thank you

#53583 - 05/31/18 07:04 AM Re: Excel file import - Skip blank cells with formulas [Re: Daboys]
Jay Converse Administrator

Registered: 07/31/00
Posts: 7727
Loc: Location, Location
Delete that row before importing
Jay Converse
Sage 300 Whisperer

Page 1 of 1 1

Moderator:  Jay Converse 
Hop to: