Transfer specific “EXCEL CELLS” to specific AS/400 DB2 fields

pts.
Tags:
IBM DB2
RPG
SQL
XML
I have an EXCEL spreadsheet that Users enter specific information and the sheet performs numerous calculations. I need to pull information from various cells on the spreadsheet and load to an AS/400 file. There will be numerous spreadsheets created during the day. I would like to load each completed worksheet as a new record to the AS/400 file. 1. I currently map the cells I need to concurrent entries on the spreadsheet - highlight the entries - then transfer to the AS/400. Is there a better way? 2. I need a quick way for the Users to seemlessly push this information to the AS/400. Thanks!

Answer Wiki

Thanks. We'll let you know when a new response is added.

We have created an automated method. When the users complete there sheets they will save them as a .csv file to a transfer directory on our network. There is a iSeries program that can either poll the directory or be run from a menu. The iSeies program ftps any file found in the transfer directory, uses cpyfrmimpf to a data base file then an RPG program takes over. Ther may be better ways, but 1. This is user driven and 2. It is automatic.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Wizard90
    You can use OZEXE Pro to map from excel to odbc. It's a free download so you could experiment. http://www.ozdevelopment.com/ozpro -James
    0 pointsBadges:
    report
  • JPLamontre
    To complete previous answer, be carefull to cell type : DB2 ask for one type only in one column, and excel can change cell type from one ligne to the next. I suggest you write a macro "SentToAS" that - select requested cells, - build a simple file something like col1 = keyname, col2=value - write this file to IFS (named with date and time to avoid duplicates) Then you can run an Iseries pgm (or have a batch loop on the directory). this way, you can control what is sent to the 400 and how it is worked after.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following