iSeires ADO Wizard

J

Jaime

Hi,
Could someone tell me how to use the iSeries ADO Wizard or how to use it.

Thanks
Jaime

This is what I'm trying to accomplish:

I need to acces the QS36F library and in this library I have PARTDESC file.
This PARTDESC file has a part number (PARTDESC) and it's description (FL002).

I want to be able to enter a part number on any cell (from range B5......B27) then select that part number and click a command button that would retreive it's description and offset it 2 cells to the right.

Does any one have any suggestions.....I have been trying everything and have not been succesfull.

Thanks
Jaime
 
S

Stephen Bye

I have tried this successfully, although it is very slow. It would be much
better to download the file to your PC and access it from there.
You can enter the following formula in the cell that is to contain the
description (d5 etc.):
=SQL.REQUEST("DSN=as400;UID=username;PWD=password",,3,"select fl002 from
partdesc where fl001=" & B5)
and when you enter a part number in B5, it will automatically fetch the
description and update cell D5.
You will need to configure an ODBC connection to your iSeries, using Control
Panel > ODBC data sources, and set the DSN parameter value to your ODBC
connection name, and your user id and password (if required - you may be
able to use default user settings instead) as necessary.

Jaime said:
Hi,
Could someone tell me how to use the iSeries ADO Wizard or how to use it.

Thanks
Jaime

This is what I'm trying to accomplish:

I need to acces the QS36F library and in this library I have PARTDESC file.
This PARTDESC file has a part number (PARTDESC) and it's description (FL002).

I want to be able to enter a part number on any cell (from range
Click to expand...
B5......B27) then select that part number and click a command button that
would retreive it's description and offset it 2 cells to the right.
 
Top