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
#50140 - 07/09/14 11:33 AM Too many fields defined
Seisa Tjela
Member


Registered: 03/21/05
Posts: 627
Loc: Lesotho; Southern Africa
Sage 300 ERP 2012
Windows 7 Ult. + SP1
MS SQL Server 2012
Office 2007

I have exported from GL Accounts into Excel and edited the spreadsheet to add more records. Then when I try to import back, I get the message:

1. Description: Too many fields defined.
2. Description: Stopped processing at record 0 in Accounts.

How do I resolve this problem?
_________________________
Rgds,
SeisaT

"The greatest test of courage on earth is to bear defeat without losing heart."

Top
#50141 - 07/09/14 12:17 PM Re: Too many fields defined [Re: Seisa Tjela]
Ettienne
Member


Registered: 06/28/02
Posts: 3680
Loc: Orlando, Florida USA
Start again, do not export all fields.
_________________________
Sage 300 ERP Certified Consultant

Top
#54436 - 09/04/20 02:46 AM Re: Too many fields defined [Re: Ettienne]
edwards142
Member


Registered: 09/04/20
Posts: 1
Loc: California
To fix too many fields defined error in Access database, you must try the following fixes:

1: Compact Your Database
2: Create A Fresh Copy Of Access Table
3: Pass-Through Query
4: Set Other Field Properties
5: Change A Field’s Data Type

To know how to perform these fixes just check out the following blogs:
http://www.accessrepairnrecovery.com/blog/fix-access-too-many-fields-defined-error

Top
#54437 - 09/04/20 02:51 AM Re: Too many fields defined [Re: edwards142]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7778
Loc: Location, Location
Why are you replying to a bloody 6-year old thread you know nothing about?

1. That will do nothing
2. That will do nothing
3. Can't be done with Sage
4. Can't be done
5. Can't be done
_________________________
Jay Converse
Sage 300 Whisperer

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: