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?


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.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].