Transfer Data from Excel to iSeries

jonam25

New Member
Joined
Oct 21, 2011
Messages
8
Hi All,

I want to export data from Excel 2007 worksheet to i Series.

Can I build an ODBC connection? Is there an option for creating a macro which will FTP data to iSeries server? Please advise.

Thanks in advance.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Sorry if I sound ignorant but what is i Series?
Is that Oracle, as in 9i etc?

If that's the case you can use a few approaches. For one-off imports you can use Toad to import spreadsheets. It's similar to the import wizards for other databases. If you will be doing it regularly you can run ADO code from Excel and push the data to Oracle.

Denis
 
Last edited:

jonam25

New Member
Joined
Oct 21, 2011
Messages
8
Hey Denis..

ISeries is AS400 which has DB2/400 database. As I need to do it regularly, I would like to use ADO connection.

I would appreciate if there is any code available for the same.
 

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390
A couple of years ago the company for which I work took on an application that runs on an iSeries mid-range system and I wanted to create a Data Warehouse that could use that data. (A brief description of my Data Warehouse can be seen in post #6 at http://www.mrexcel.com/forum/showthread.php?t=504537)

I only needed 'read' access for linking to Microsoft Access/Excel so do not have any experience of transferring data to the iSeries.

I could only find one book to help me but I did consider the price to be rather high. It contains some VBA but the book was very useful and informative. The book details (and a 'look inside' option - you will be able to see the Table of Contents and Index) can be seen at:
http://www.amazon.com/i5-Microsoft-...0573/ref=sr_1_3?ie=UTF8&qid=1319845208&sr=8-3
 

Watch MrExcel Video

Forum statistics

Threads
1,109,004
Messages
5,526,225
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top