Populating a lis/combo box in excel with access data

Enrico Lisk · Oct 3, 2003

i need to know how to populate a MS Excel List/Combo Boxes
with data from a MS Access table

i know how to fill excell cells with Ms Access Data

thank u

Tom Ogilvy · Oct 3, 2003

This is an example using DAO, but once you have your recordset, the
procedure should be the same:

http://support.microsoft.com/default.aspx?scid=kb;en-us;164923&Product=xlw
OFF97: How to Fill a UserForm ListBox with Database Values

Finally found this one: This is specific to ADO

http://support.microsoft.com/?id=244761
XL2000: How to Use ADO to Return Data to a ListBox or ComboBox

Populating a lis/combo box in excel with access data

Enrico Lisk

Tom Ogilvy