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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.