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
daparnin@xxxxxxxxxxxxxx





                                                                                
                                                     
                      "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                        
                      idrange.com                                               
                                                     
                                                                                
                                                     
                                                                                
                                                     
                      11/23/2005 11:35 AM                                       
                                                     
                      Please respond to "SSA's BPCS ERP                         
                                                     
                      System"                                                   
                                                     
                                                                                
                                                     




Hi All,

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

Please help!

Isaac.

--
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 ...

Replies:

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.