MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I would like to transfer datas from As/400 to Excel 95


Posted by Marc des deserts on April 26, 2001 4:08 AM

Everyday I receive datas from customers on AS/400.
But all our stock system is managed on Excel. At the moment, every morning we have to enter all the datas manualy on Excel 95.
I would like to know if it exists an easy way to transfers this datas to Excel.

Any help would be appreciated.
Thanks
Marc


Posted by Ed on April 26, 2001 4:18 AM

Marc,

I work with a program called "Revive". It is a program that will take an AS400 spool file and run it through a filter you set up. From that point it transfers the information into an Excel or Access file. From that point you can do just about anything. The company, Madec Computing Ltd, is out of Ireland.
Ireland Phone: Int+353 21 272611.
New York Phone: 1 800 316 1158
Fax 1 800 828 5276

This program has done wonders for me.

Ed

Posted by doug on June 06, 2001 5:28 AM

You can use MS Query which comes with a office license....it can import using odbc. If you need more help let me know