Hi

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
...