ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2002 (https://www.excelbanter.com/excel-programming/286833-excel-2002-a.html)

Priyesh

Excel 2002
 
Hi,

How to get ado recordsets from excel2002. I use the
connection string
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= " & Name & ";Extended
Properties=Excel 8.0;" & _
"Persist Security Info=False"

It reads well for all other than Excel 2002. Help me.

Thanx in advance

Priyesh.


All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com