Excel to Access
I have an Excel template that uses dropdowns to gather data. I want to be
able to use the responses to the drop downs to fill in values in Access. When I import the worksheet, the dropdown part is blank! Is there a solution to this? -- Thanks for your help! |
As answered in microsoft.public.excel.misc --
If the dropdowns are combo boxes, you could link them to cells in the table. Then, when you import the table, it will include the data that was selected in the combo boxes. Or, instead of combo boxes, you could use data validation lists. There are instructions he http://www.contextures.com/xlDataVal01.html BAZ wrote: I have an Excel template that uses dropdowns to gather data. I want to be able to use the responses to the drop downs to fill in values in Access. When I import the worksheet, the dropdown part is blank! Is there a solution to this? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com