Update query on as/400

["Silva Marco" <Marco.Silva@xxxxxxxxxxxx>]

Hi,

 

I have a file with product specific data.

 

 

In that file I have a column called rfismi ( item reference) .

 

I have a excel spread sheet with the item reference information and also the other columns information.

 

What I want is to create an update query in order to update the column or field as you prefer with the item reference information.

 

I have this ideas to make it possible:

 

1 - With the tool that allow to send information to iSeries, I think that if I replace all the AS/400 information with the new one that I can do it?

 

2 - Maybe if create a new table where that information is, I can with SQL create a query that updates table1 with the information that is on table2

 

3 - I create a connection to AS/400 with iSeries ODBC driver. I can read data from as/400 trough access but I can't update that date. So, my other idea was to update data from Access. But Access can't update a recordset of AS/400

 

How can I solve my problem? Any of this ideas my solve my problem?

 

Any more ideas?

 

Thanks,
Marco


P 
Antes de imprimir este e-mail pense bem se tem mesmo que o fazer. Há cada vez menos árvores.
Before printing this email, assess if it is really necessary to do so.