Greg,

Thanks, it does help but not with this problem.
What you have below will bring back everything on the table, in the instance
I need to use it that is not possible as there are over 172,000 records on
this table (and obviously only 65,532 will fit onto an Excel spreadsheet).

I have used a ComboBox in MS Access to achieve what I want to do but don't
know how to do it in Excel.
I want to click on the ComboBox or start typing an item code and the item be
displayed in the dropdown box.

Dean

"Greg Koppel" wrote in message
...
Hi Dean,

Use the macro recorder to find the appropriate source and connection type.
After turning on the recorder from the Tools/Macro menu, go to the Data
menu
and choose Get External Data / New Database Query. Choose the data source
type from the first dialog. If it is not in the list, you will have to try
something else. If it is, another dialog will appear asking for the
location
of the file. Find it and create a simple query and end the macro
recording.
View the recorded macro for the details you seek.

HTH, Greg

"Dkso" wrote in message
om...
Hello,

I want to be able to query an ODBC database through a Combobox on a
VBA form. I can do it if the data is stored in cells on the
spreadsheet but I have other info that is on the mainframe system that
I need to access.

Any help would be appreciated.

Thanks
Dean