All,
In my spreadsheet, I have a command button that calls code to create a
recordset based on a SELECT statement which queries a table in Access.

I have tried this in Excel 2007 and Excel 2010 and get the same problem.

I have a reference to DAO 3.6 in my project. The following code snippet
fails with a message box with a Red X in the middle, with NO TEXT describing
the error, and an OK and Help button. The Help button gives me nothing.

Can somone point me in the right direction on how to query Access for some
data without importing the entire table (it is very large).

Thanks,
Steve