Append query from excel vba?

A

Accessor

Hi all. I've been scouring all the boards and can't quite find something to
translate to my purposes. I have an append query in access that appends new
(unique) records from one table to another. I do a lot of access manipulation
from my excel vba modules, can I run this append query from there? Anyone
have a nudge for me as to the syntax involved?

Thanks in advance...

Kevin
 
P

PieterLinden via AccessMonster.com

Accessor said:
Hi all. I've been scouring all the boards and can't quite find something to
translate to my purposes. I have an append query in access that appends new
(unique) records from one table to another. I do a lot of access manipulation
from my excel vba modules, can I run this append query from there? Anyone
have a nudge for me as to the syntax involved?

Thanks in advance...

Kevin
Click to expand...

You should be able to use either an ADO command object or DBEngine(0)(0).
Execute "QueryName"
 

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

Adding data to MS Access from csv file 0
Make one final list from four sources 1
query field names changing to expr#: 8
Access 2002 Append Query Problems 2
Only first few records visible in table after running append query 1
Help Access Append Query 6
Append ODBC tables into Access Table 5
Append Query 7

Top