I haven't done QAT records but I have done QDB when we were setting up tax
books that had previously maintained in an Excel spreadsheet.  It's been a
year or so but I think that I can remember the basics.  I tried CPYFRMIMPF
and CPYFRMSTMF but had no luck due to a field or two that had a single or
double-quote (' or ") that screwed up the command.  In the end I imported
the spreadsheet into a MS-Access database then created an ODBC link to a
DB2 file on the AS/400 that I had created.  I wrote a program to move the
records from the temporary file to the QDB file.  There was also some
editing involved to fix things that didn't quite match.

This was a one-time project and involved quite a bit of work but it was
better than the amount of labor needed to hand-enter all of the records.  I
would have to do some looking to find the program.  Even then, I doubt that
it would be of much good to you since it was based on our spreadsheet.

Dave Parnin
Nishikawa Standard Company
Topeka, IN  46571

                      "antwi, isaac a."                                         
                      <iantwi@xxxxxxxxxxxxxxxxxxxxxxx>                To:       
"SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>        
                      Sent by:                                        cc:       
                      bpcs-l-bounces+daparnin=niscoseals.com@m        Subject:  
[BPCS-L] Fixed Assets Loading                        
                      11/23/2005 11:35 AM                                       
                      Please respond to "SSA's BPCS ERP                         

Hi All,

Does anyone have a program that will upload assets into BPCS?  I am
struggling to setup some 5,000 assets.

Please help!


This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

 Delivered-To: daparnin@xxxxxxxxxxxxxx

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.