Vesion of Excel in Connection string

P

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
 
Top