Send Access Data to excel via excel VBA

peelamedu_bulls

New Member
Joined
Nov 30, 2005
Messages
29
I want to query a access table and fetch some rows and populate a excel workbook. I would like to do it in a excel VBA macro.

If a user clicks a button in excel, then the SQL query should run on the access table and populate the selected rows in the xcel sheet.

Can this be done in a Excel macro?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Alan2005

New Member
Joined
Oct 12, 2005
Messages
22
This can certainly be achieved. Search the board for SQL code.
There are a lot of helpful posts that will point you in the right direction.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,139
Messages
5,576,308
Members
412,716
Latest member
thviid
Top