Connect to a table

J

JoeandTel

in VBA how do I use a sql statement to obtain data? How do I create a record set?
 
A

Adrian Jansen

Recordset occurs as both DAO and ADO. You probably want DAO, use

Dim rs as DAO.Recordset

Also your SQL needs a semicolon to end:

Set rs = CurrentDb.OpenRecordset("SELECT * FROM Employee;")

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 

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

Incone & Expenses Statement 0
Adding connection points to shapes manually/programmatically 0
Adding data to MS Access from csv file 0
Using <= in countifs statement 1
How to have two tables on same line? 1
VBA Export to PDF 0
Append Crosstab Query to Existing Table 0
Consolidation Table from Different Excel Tabs with Different Format 1

Top