Version of Excel in Connection String

[Prasun]

Hello:

I am using the following connection string in my program


Code:

XLFileConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & filename & _
";Extended Properties=""Excel 8.0;HDR=YES;IMEX=1"""




Is there any other versions of Excel i can put in this connection string
instead of Excel 8.0. Can I put excel 9.0 or 10.0. Is it possible to put an
earlier version like 5.0 (is there an excel 5.0?).

I guess i want to know what are my options are for that value.

Thank You
Prasun

 

[Paul Clement]

¤ Hello:
¤
¤ I am using the following connection string in my program
¤
¤
¤ Code:
¤
¤ XLFileConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
¤ Source=" & filename & _
¤ ";Extended Properties=""Excel 8.0;HDR=YES;IMEX=1"""
¤
¤
¤
¤
¤ Is there any other versions of Excel i can put in this connection string
¤ instead of Excel 8.0. Can I put excel 9.0 or 10.0. Is it possible to put an
¤ earlier version like 5.0 (is there an excel 5.0?).
¤
¤ I guess i want to know what are my options are for that value.

Just use 8.0 - it's the latest (and probably last) version of the Excel ISAM driver.


Paul
~~~~
Microsoft MVP (Visual Basic)