problem opening excel file thru ADO

**darre1** · Feb 20th, 2002, 06:08 AM

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...

any ideas?

darrel.

**crispin** · Feb 20th, 2002, 06:19 AM

(obvious question)

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

**darre1** · Feb 20th, 2002, 06:20 AM

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

**crispin** · Feb 20th, 2002, 06:24 AM

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

ADO 2.7

ADO 2.6

ADO 2.5

with no probs........

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

**darre1** · Feb 20th, 2002, 06:28 AM

-2147467259

**crispin** · Feb 20th, 2002, 06:33 AM

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

**darre1** · Feb 20th, 2002, 06:43 AM

i'll give it a go...

**darre1** · Feb 20th, 2002, 06:53 AM

nope, still buggered.

**darre1** · Feb 20th, 2002, 07:09 AM

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

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

**crispin** · Feb 20th, 2002, 07:11 AM

change your reference to ADO 2.7.....

Thread: problem opening excel file thru ADO

Thread Tools

Display

problem opening excel file thru ADO

Posting Permissions