Re: GLH records uploading problem

[Paul Holstein <holstein13@xxxxxxxxxx>]

Victor,

If I had to guess, I'd say you are trying to link to an Excel spreadsheet
and then uploading that to the AS400.  If that is the case, then I'd look at
the data in your table in see if you see any errors before you post.  Also,
it is always better to copy all your data from one sheet to a "Values Only"
sheet.  That way you avoid problems with formulas.

BTW, why are you trying to post to GLH directly?  If you are trying to post
something, you are better off going to GJW or even GBH and GBL.  Otherwise,
you'll have to run the GSB to GLH resync program to correct your balances
and you also won't have any validation performed by CEA on your account
numbers, rules, closed periods, etc.

If you have any further problems, please feel free to call me on my cell
phone at 954-536-6678.

--Paul Holstein
iWork Software, L.L.C.

On Mon, 24 Jul 2000 15:07:04 +0800, BPCS-L@midrange.com wrote:

>  Does anybody knows how to upload records to GLH table from Microsoft
Access 97 using Client Access's ODBC driver ?  I've perform some tests for
the uploading and found that I can upload records to GHH table but not the
GLH table.
>  
>  The error messages I've got from Microsoft Access when I append records
to GLH table is as below :
>  
>  "Microsoft Access can't append all the records in the append query.
>  
>  Microsoft Access set 3 field(s) to Null due to a type conversion failure,
and it didn't add 0 record(s) to the table due to key violations, 0
records(s) due to lock violations, and 0 record(s) due to validation rule
violations."
>  
>  I've used exactly the same definitions for the fields in the linked table
GLH to create the table for append.
>  
>  The BPCS version we're using now is V6.0.02 Full C/S Mar98 Cum.
>  
>  Regards,
>  
>  Victor
>





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---