Using Where Clause in VBA to extract from Access to excel without access

Hello,

I am using the below query to extract information from an MDB file. The issue is that it extracts everything on the file.

I need only if it is equal to a particular value eg. TPX column = cell value on the excel sheet to extract on my excel sheet
And I need only if it is equal to a particular value eg. Time column = cell value on the excel sheet to extract on my excel sheet

Thanks in advance

Please Login or Register  to view this content.

The easiest thing you can do is create the query in your database and copy the sql from the query and add it to your code.
Then you can do something like this below, Makes it alot faster then looping thru the recordset

Please Login or Register  to view this content.