ADO connection not opening in Excel 2003

S

Smallweed

Hi, I've been setting the following connection string with no problems in VBA
in Excel 2002:

cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
ThisWorkbook.Path & "\" & ThisWorkbook.Name & ";Excel 8.0;HDR=No;IMEX=1;"

However, this causes my Excel 2003 to crash horribly when the connection is
opened.

connectionstrings.com gives the following:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended
Properties="Excel 8.0;HDR=No;IMEX=1";

I've tried including the "Extended Properties=" and tried most permuations
of quote marks and Chr(32) - all just make the VBA stop in its tracks rather
than crashing Excel.

Anyone got any ideas? Do I need a different connection string for Excel 2003?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO connection to Excel 2007 *.xlsx files? 8
ADO connection to a protected workbook? 3
Macro doesn't work any more 0
ADO Recordset 0
Getting error:External table is not in the expected format.while u 0
export excel data to access table using ADO 0
Excel prompts for VBApassword after saving workbook under new name and exiting excel 0
Table format - connection string problem 1

Top