Hi Kevin.

I got the problem solved. It was the connection string:

ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
ConnString &= ExcelFileName & " ;Extended Properties=" & Chr(34) & "Excel 12.0;HDR=NO;" & Chr(34)

The double quotes around the extended propertied were required.

Informative error message, huh?