Run Append Query from VB

B

Bill Sturdevant

I should know this but am drawing a complete blank!!!

I have an Append query.

How do I run it from code?
 
A

Allen Browne

Best:
dbEngine(0)(0).Execute "Query1", dbFailOnError

Also possible:
DoCmd.RunSql "Query1"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:D[email protected]...
 

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

Append Crosstab Query to Existing Table 0
Adding data to MS Access from csv file 0
Running Apend,Delete and Make queries with VB 2
Running 2 queries at the same time using VB 1
Appending an existing table with imported Excel data 0
Run Append Query from ControlButton on Form 3
How to write an append query on a recordset 2
DoCmd.RunMacro 3

Top