ADO

[POIT]

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

 

[Nick Hodge]

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
(e-mail address removed)

 

[POIT]

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

 

[Nick Hodge]

Poit

Not sample as such but the implementation could be as simple as recording a
macro taking the menu options Data>Get External Data>New 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
(e-mail address removed)