Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to populate excel combo box from a database ?

Status
Not open for further replies.

smilemax

Computer
Joined
Dec 21, 2001
Messages
2
Location
US
Can canyone let me know how to populate a combo box in excel from access database query/table
Thanks
SMX

 
That's a pretty daunting task, if you ask me. I've done the reverse, sort of: Export a table in Excel to Access, from Access, process the data into a Report, export the Report into another Excel spreadsheet. Combo boxes are problematic to work with and I've not seen one in Excel. You might try to play with the TransferSpreadsheet funtion and other Access actions/functions. My experience is that ambitious Access work is pretty darn frustrating.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top