I'm looking to pull data from a csv file "Data.csv" and get the StartTime from the csv file into the MakData.xlsm file.

MakData.xlsm

Data.csv

myStr = Worksheets(1).Range("C1")
     myTime = Format(myStr, "hh:mm:ss AMPM")
     stSQLstring = "SELECT StartTime FROM [Data.csv] where StartTime ='" & myTime & " '"
I get no StartTime pulled into the MakData.xlsm file, but there is a StartTime at 1:26:00 PM in the Data.csv file.