Dynamic display of data from SQL to excel

[Sai Prakash]

Hi All,
I am very new to VB and macros. I need your help in completing the
tasks assigned to me. Please help. I have been reading many webpages
and groups in vain.
The following are the tasks i need to accomplish
1. In excel open a userform with a combo box that lists the tables in
the DB. (If it is not possible I dont mind hardcoding it)
2. When user selects a table, another combo should select a list of
columns in the table.
3. The user should be able to multiselect the columns and then the
values should populate in excel.

If there is anyother way to do this, pls give your inputs.

Thanks

Priya

 

[Doug Robbins - Word MVP]

This newsgroup is intended for questions concerning the use of Visual Basic
with Word. For assistance with Excel, you should post to the
microsoft.public.excel.programming newsgroup.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP