Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel connection to ODBC database | Excel Discussion (Misc queries) | |||
Update database from ODBC query | Excel Discussion (Misc queries) | |||
ODBC database query | Excel Discussion (Misc queries) | |||
ODBC Drivers to a SQL database | Excel Discussion (Misc queries) | |||
how can I create a ODBC database in excel | Excel Worksheet Functions |