Get data from Access to Excel Combobox

[Lucifix]

Hi,

since I have search almost 90% of all web I didn't find any tutoria
that would explain me how would I get data from Access file *.mdb t
Excel combobox which is inserted on specific sheet.

I would be realy grateful if someone post a list to tutorial or explai
it here.

Thank you!
Uro

 

[DM Unseen]

There are several solutions. but somwething like this should work:

First use Date->External Data-> New database query and connect to your
Access database. Create a query that gets the required list onto a
sheet.

Now use a Combobox and referene the range of the query. If yoy use the
combobox from the "Forms" menu bar, you can even use the (defined) name
of the query, which will then always accommodate the correct amount of
rows.

DM Unseen

 

[Guest]

http://support.microsoft.com/kb/244761/en-us
XL2000: How to Use ADO to Return Data to a ListBox or ComboBox

 

[Lucifix]

Thanks I will check it out as soon as possible