Table Imports

[MikeKohler]

Hi, I have been importing tables from PSQL into Access using an OBDC connection. The tables I have been importing are PT001, RM00102 and SF003, these are tables from Great Plains Dynamics. Recently, however, I have been having trouble importing table SF003, I keep getting the error, [Pervasive][OBDC Client Interface][LNA][pervasive][OBDC Engine Interface][Data Record Manage]Buffer to small, data trucated (#1006).
I was wondering if anybody else has received this erro.
Thank you,
Michael Kohler
mkohler@telusplanet.net

 

[mirtheil]

Sounds like there's a problem with either the data in the SF003 table or the table defintion itself. The fact that it was working and is now failing leads me to believe it's a data issue. Try importing only a few records to see if that works. If it does, then expand the import until you can narrow down which record or records is causing the problem. Once you've got the offending record(s), you can modify or delete them from Great Plains to bring them back to compliance.
mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician