Updating a table with a query

P

Paul Simpson

Hi, (hopefully) a really simple one here...

I have a string variable in VBA which contains a query
(it's actually an INSERT if that makes any difference).
How do I execute it? The tables concerned are in the
local access database, so I guess my question probebly
involves the bame of the connection!

As always, darned urgent so all help (particularly quich
help!) gratefully received.

Thanks

Paul
 

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

Appending and Updating Tables with VBA 4
Create append/delete query into a table that has multi-valued fiel 2
Table selection in Query 3
How Can I Update a Table from a Totals Query? 3
How to do an append query to a table from a recordset 2
Delete a Query, or Empty it and Reload With New SQL? 2
Creating a new record in only one table of underlying query 4
updating a record from another table. 3

Top