Userform to Browse MS Access DB

[harishs]

Hi Experts,

Looking at the features of Excel, i want to learn n do more in Excel.

Here is my request, not sure if this is doable or too much of ask. I am giving a try.

I want to do following with a Userform in Excel.
1. Browse for the MS Access DB File and Load
2. Bring the list of Tables available in the MS Access file
3a. Select the table and load data completely to spreadsheet
or / and
3b. Select the table and show all column headers of the table... allow user to select columns and load selected column data only to a spreadsheet.

If this is not doable in userform, please suggest a way out.

Regards,
Harish S

 

[Paul Ked]

A nice project... It is all 'doable'.

Load the DB into a worksheet (if it will fit).
Filter the info you want from the worksheet onto the userform.

 

[harishs]

Thanks for giving me hope Paul.

Yes, Load DB>> select table>> filter down the information thru Userform and load data to Spreadsheet.

Regards,
Harish S

 

[harishs]

Hi Experts,

Looking for a solution. Please help.

Regards,
Harish S

 

[Paul Ked]

From your original post

i want to learn n do more in Excel.

How far have you got?