Get matching values using ADO from closed CSV file

Originally Posted by romperstomper

I don't see where your code makes any attempt to read from the CSV file?

Hi romperstomper,

I put the code almost as a reference of what I think could be the way, using ADO, but I'm a beginner in that area.

I was hoping to understand how that example works and then try to change to a csv, but even that example not seem to show the output as they say.
In my case I think the middle part of the code would be something like:

objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=C:\MyFiles\;" & _
        "Extended Properties = ""text; HDR=No ""," 

objRecordset.Open "Select * FROM Origin.csv Where X = Y", _
    objConnection, adOpenStatic, adLockOptimistic, adCmdText

The part in red X=Y should be values in column A of Results.xlsx that are equal to values in A of Origing.csv. I don't know how would be the syntax here and how to retrieve values in other columns for matching rows.

Like a start I tried following exactly with file in example and didn't work for me, actually my computer hanged when the "Do until EOF loop" was executed.

Maybe you can help me to get the desired result.

Many thanks in advance.