Running a Access query 
Author Message
 Running a Access query


Hi,
   Does anyone have any sample for running an Access query
from DAO??

Dim db As DAO.Database

Set db = OpenDatabase("d:\My Documents\Accessdb.mdb", False, False)

db.QueryDefs("MyQueryDef").Execute

Or code for appending data from access table to
another? Thanks in advance

sqlString = "INSERT INTO [AccessTable] SELECT * FROM [Table2]"


Microsoft MVP (Visual Basic)



Mon, 09 May 2005 23:05:39 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Running an Access Query by Query Name

2. Running an Access Query by Query Name

3. Running an Access Query from VB4

4. Running an Access Query from Visual Basic

5. Can I run an access query in VB?

6. Can I run an access query in VB?

7. How to run an Access Query from VB 5.0

8. Running an Access query from VB

9. Running an Access query?

10. Access queries run from VB gobbling 10 times the disk spaces as when run locally

11. Trim() function in query can't be run in Access Runtime Environment

12. Run Access.mdb query from Excel

 

 
Powered by phpBB® Forum Software