You can use the SQL.REQUEST function with a SELECT statement to fetch the
field values from the corresponding records in the AS400 file via ODBC.

"Rick Dilley" wrote in message
...
This is my first post to this NG and I may be in the wrong place so please
be patient.

Problem:

I periodically receive an email with an attached Excel worksheet. .XLS
this is received at the desktop of a domain user in our domain.
We have an AS400 on the network as well.
We would like to take certain information from 2 different columns and
access a database on the AS400 to retrieve 3 data fields and place them
into
3 new columns, when a "hit" exists in the AS400 database.

ODBC link to the AS400 data within Windows 2000 Professional is possible.

I am not adverse to having a batch extract from the XLS to a file that
could
be uploaded to the AS400 and matched/updated on the AS400 and then
downloaded back into a new XLS.

The process should be fairly simple as the users is non-technical.
I would like to reduce the likelihood of errors by having as little user
intervention as possible.

OK you whiz kids... here is your chance to really demonstrate your
"interoperability" design skills.

Thank you in advance.



Rick Dilley


(908) 686-0513 # 263
(908) 696-9165(fax)