Run MSAccess Action Query From Excel

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

Hi can someone tell how I can run a action query in Access
from Excel VBA.
TIA
Charles
 
Thanks I have sorted it now!

Sub RunActionQuery()
'
Dim db As Database

Set db = DAO.DBEngine.OpenDatabase(DatabasePath2, False)

db.Execute "qryAppendStation"

db.Close

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MSAccess output to Excel losing formatting of number 1
Access #Error & Excel Pivot 0
Replacing Text In VBProject Module 10
Macro that will insert a simple text string in top cell of text file 1
Resize and position excel window 2
Run Access Action Queries from Excel? 1
Refresh an Access Query using VBA code in Excel 6
working with MsAccess in multiuser environment: error Cannot start 1

Back
Top