Converting Data in Excel to PF on DB2/400

105 pts.
Tags:
DB2/400
Microsoft Excel
Physical File
Hi All,

I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it.

Thanks in advance



Software/Hardware used:
Excel & DB2/400

Answer Wiki

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

There are a couple of ways to do what you want.

If you have Client Access “Personal Communications iSeries Access for Windows”, there is a button on the tool bar to upload files. You’ll need an FDF which is easy to get if you download the file first using the bottom on the tool bar to download files. Proceed with caution.

Another way is with the VBA in Excel and the Client Access ODBC driver.

Quick and dirty updates aren’t that tough, but if you want to make sure users don’t enter the wrong thing in the wrong place, it gets more complicated – too complicated for this forum.

If you want a template for updating AS/400 files from Excel, e-mail me and I’ll send you one. I intend to make this sort of thing a future topic in my blog: Beyond Excel.

Discuss This Question: 1  Reply

 
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
  • ToddN2000
    I have had more luck when the Excel file is a .CSV file type. The other problem area is with dates, for some reason dates in Excel do not transfer over to a DB2 file as numeric correctly. It takes some playing around. I still use the data transfer add-on in Excel.
    15,605 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