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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only