Reply to thread

Message: [QUOTE="GS, post: 6453437"] Robert Crandal brought next idea : It's with all the double quotes!!! Try this: szConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "DataSource=C;\MyData\data2.xls;" & - "ExtendedProperties=""Excel 8.0;HDR=No;IMEX=1"";" Note that while multiple ExtendedProperties are wrapped in double quotes AND delimited by the ; character, the string must be ended with another ; character followed by the normal closing double quote. IOW, your string is missing the ; character before the closing double quote! [/QUOTE]