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
Daboys
Member


Registered: 08/17/05
Posts: 351
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

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


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

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: