External Database Lookup via ODBC

  • Thread starter Thread starter rward68
  • Start date Start date
R

rward68

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
 
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
 
Back
Top