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 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