SQL Queries in VBA

Posted by Micke A on September 04, 2001 10:08 AM

Want to run SQL questions to retreive records from a DBASE file into a sheet.

I need to create the SQL string in VBA code based on selections in a form.

How do I execute SQL queries from VBA ?

Posted by Dax on September 04, 2001 4:10 PM

Use either ADO or DAO. Set a reference to either of these libraries in the VB editor. You'll then be able to create recordsets using SQL.

If you need examples/further info please post.

Regards,
Dax.

Posted by Micke A on September 06, 2001 8:59 AM

Thanks,

It works great !

I now use DAO to execute SQL strings

/Micke