External Database Lookup via ODBC
 

My users have asked me to add a function to a spreadsheet they use fo
quoting. They would like to be able to enter a part# in a certai
cell, click a button and have the part description, price, etc fill i
from a table on our iSeries via ODBC.

I've done very little VBA programming so I'm looking for some tips t
help me get started.

Thank

--
Message posted from http://www.ExcelForum.com

External Database Lookup via ODBC
 

All from the top of my head, I don't have a database in front of me to test.

From the Data menu, select Get External Data | New Database Query.
Through a series of dialogs, you'll get to Microsoft Query.
You need to use a parameter in your criteria panel.
eg.
=[Choose a Part Number]

Then once you've returned the query to Excel it will create a table.
You need to right-click the table, edit the parameter and make it use an
existing cell (you may want to click the tick box which makes excel refresh
the query whenever that cell changes).

Rob


"rward68 " wrote in message
...
My users have asked me to add a function to a spreadsheet they use for
quoting. They would like to be able to enter a part# in a certain
cell, click a button and have the part description, price, etc fill in
from a table on our iSeries via ODBC.

I've done very little VBA programming so I'm looking for some tips to
help me get started.

Thanks


---
Message posted from http://www.ExcelForum.com/