Connect to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in VBA how do I use a sql statement to obtain data? How do I create a record set?
 
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
 
You must log in or register to reply here.

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

Example Of VBA SQL Statement 0
How to export table from outlook into ms access table? 0
Using DSUM to get running total on a filtered form 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Trying to save a SELECT statement as the Record Source for a Form 2
Retrieve Data from Table not on Form 2
Open a word mail-merge document from Excel VBA 1
Design advice - changing data not bound to a form 2

Back
Top