Running an SQL statement into Access from Excel

[munkayboi]

Hello everyone,

I'm trying to run an SQL statement into an Access database from Excel. Here is the code I have so far:

Please Login or Register  to view this content.

The following code runs perfectly fine. The recordset comes back with the statement results. However, when I try to put a 'Where' clause into the SQL statement like so:

Please Login or Register  to view this content.

... the whole thing blows up and gives me an Automation Error and an Unspecified Error. The field names are all spelled correctly. The connection and cursor types seem fine as well since it returns results WITHOUT the 'Where' clause. Anyone have any ideas??? Any feedback would be greatly appreciated.

[bhofsetz]

You may need a line break in your strSql between the ' select * from Yield ' and the ' where Selection = 'EPI' '.

Try turning on the macro recorder then going through 'Data' - 'Get External Data' - 'New Database Query' and see how that SQL statement is recorded.

HTH

[munkayboi]

Looks like that wasn't the problem, but a buddy of mine managed to figure it out. Apparently, the code didn't like the field name 'Section'. Not sure why, but I changed the field name from 'Section' to 'Type' and it works great. Thanks anyway for your help!