Get data from Access to Excel Combobox
 

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

--
Lucifi
-----------------------------------------------------------------------
Lucifix's Profile: http://www.excelforum.com/member.php...fo&userid=2917
View this thread: http://www.excelforum.com/showthread.php?threadid=52950

Get data from Access to Excel Combobox
 

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

Get data from Access to Excel Combobox
 

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

--
Regards,
Tom Ogilvy



"Lucifix" wrote:


Hi,

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

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

Thank you!
Uros


--
Lucifix
------------------------------------------------------------------------
Lucifix's Profile: http://www.excelforum.com/member.php...o&userid=29179
View this thread: http://www.excelforum.com/showthread...hreadid=529507

Get data from Access to Excel Combobox
 

Thanks I will check it out as soon as possible ;)


--
Lucifix
------------------------------------------------------------------------
Lucifix's Profile: http://www.excelforum.com/member.php...o&userid=29179
View this thread: http://www.excelforum.com/showthread...hreadid=529507