ADO
 

Hi,
Does anyone have any code or examples on how to connect to an Iseries.
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
Poit

ADO
 

Poit

I wouldn't like to try this on the fly. I have built a few models in Access
and would therefore expect this to be the same in Excel, providing there
won't be more than 65536 rows.

This is to trigger a refresh query on each opening of the workbook or by
command button, at any time felt necessary of the whole data file.

This would then keep the data 'locally' on another worksheet and you could
use a simple VLOOKUP function to look up the description.

Works well in Access. If there are many records, even if you are locally
connected, it would take a long time to refresh each the data via you
suggested route

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS



POIT wrote:
Hi,
Does anyone have any code or examples on how to connect to an Iseries.
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
Poit

ADO
 

Hi Nick
Thanks for the reply........I have tried that and the only problem is that we are constantly adding new part numbers and we have many people that would using this form........I don't know much about ADO and was told that that would be the rout to go.....Do you have any samples of this

Thank
Poit

ADO
 

Poit

Not sample as such but the implementation could be as simple as recording a
macro taking the menu options DataGet External DataNew Database query...
The query definition is also infact saved with the workbook, so once you
import the data once, the refresh button could simply be used from the same
menu

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS



POIT wrote:
Hi Nick,
Thanks for the reply........I have tried that and the only problem is
that we are constantly adding new part numbers and we have many
people that would using this form........I don't know much about ADO
and was told that that would be the rout to go.....Do you have any
samples of this.

Thanks
Poit