I am attempting to connect to an excel file to check if the column names is correct (to validate that it is the file I expected) using the following code:
Code:
dim cn as adodb.connection dim rs as adodb.recordset cn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\..\file.xls" & _ ";Extended Properties=""Excel 8.0;HDR=YES""" rs.open "SELECT