Import and Export data from AS/400 using ODBC

85 pts.
Tags:
AS/400
Microsoft Excel
ODBC
I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 8  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.
  • ToddN2000
    You can use the Excel Client Access add in to upload and download to the AS/400. How are you planning to do the uploads, via a script or other method?
    135,425 pointsBadges:
    report
  • Geek511
    I created ODBC connection inorder to import data from As400 Database file , how can export or update data into AS400 database file . Is the above procedure is not correct , can you suggest me the correct way for Import and export database file into excel . 
    85 pointsBadges:
    report
  • ToddN2000
    There are a few possible ways of doing this data transfer. Is this going to be a manual or automated process? If there is a script that is going to handle this, what language is it written in?
    135,425 pointsBadges:
    report
  • Geek511
    I am not using any scripts as per my knowledge , i am jsut using odbc connection to import the data .I am asking how to export the data . 
    Steps for Import the data : Create a odbc connection and Open excel and select Data option ->then From other sources -> Microsoft query ->:Select odbc connection created -> after few mandatory steps you can import the data 
    85 pointsBadges:
    report
  • ToddN2000
    The only way I have exported data from Excel to the AS/400 or i-Series is using the Client access add in. With this you can export your data. I have better luck with .CSV file formats rather than .XLS or .XLSX. This add in makes life a lot easier.

    135,425 pointsBadges:
    report
  • melindabeal
    How do you import data from AS400 to excel
    15 pointsBadges:
    report
  • Subhendu Sen

    @melindabeal, First take spool file report as a text file using iseries navigator & then import it right into excel. When using excel text Import wizard to import as/400 data contained in spool files make sure you select fixed width.

    141,290 pointsBadges:
    report
  • ToddN2000
    @melindabeal, you could also use the as/400 addin for Excel. This let's you import a file directly or even write a SQL script to retrieve the DB2 data from the i-Series.  info on the addin can be found here.
    135,425 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.

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

Following

Share this item with your network: