Tags: as400, database, db2, excel, import, mysql, oracle, spreadsheet, sql

Import EXCEL Spreadsheet to AS400

On Database » DB2

590 words with 2 Comments; publish: Thu, 29 Nov 2007 07:04:00 GMT; (250123.05, « »)

Can one and if so, how does one import the data from an EXCEL spreadsheet to the AS400 to use as a table.

All Comments

Leave a comment...

  • 2 Comments
    • You can try saving the file as CSV and then IMPORTing into your DB2/400 ...

      Or consider using an application which uses ODBC to access the datasources ...

      HTH

      Cheers

      Sathyaram

      #1; Tue, 11 Dec 2007 17:40:00 GMT
    • Hello!

      Try **iGetExcel** at www.goering.de

      This is a native running solution which allows to read Excel native on the iSeries 400, shows the sheet in subfile, transfers to any PF....

      Regards

      Andreas Goering

      GOERING iSeries Solutions

      #2; Tue, 11 Dec 2007 17:41:00 GMT