problem opening excel file thru ADO

Hello all,

i've got this piece of code to open an excel spreadsheet using ADO, which has been working ok uptill now...

VB Code:

cnExcel.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=" & strFilePath & ";" & "Extended Properties=""Excel 8.0;HDR=NO;IMEX=1"""
    cnExcel.CursorLocation = adUseClient
    cnExcel.Open
    
    rstImport.Open "SELECT * FROM [Sheet1$]", cnExcel, adOpenStatic, adLockReadOnly

i've error trapped it and get an "unspecified error" on the last line.

I'm using MDAC 2.7 (ADO 2.6) and i can't work out what the problem is coz i haven't changed the excel file... :confused:

any ideas?

darrel.

(obvious question)

Have you checked your project references since you installed MDAC 2.7 - to see if anything has the "MISSING" prefix.....

yup, thats all ok, project compiles without any problems too.

I just ran your code with a reference to the following:

ADO 2.7

ADO 2.6

ADO 2.5


with no probs........:confused:


are you getting any error number at all....

-2147467259

:eek:

Try reinstalling MDAC and going again......

i'll give it a go...

nope, still buggered.

oh come on people, don't tell me i've got everyone stumped!

:D

anything else i can do to help you help me???
more code etc???

change your reference to ADO 2.7.....