View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Priyesh[_2_] Priyesh[_2_] is offline
external usenet poster
 
Posts: 1
Default ado connection string for excel 2002


Hi,

I am using the below mentioned connection string to read from excel
sheet using ado. It works fine for me except for excel 2002.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Name & ";Extended
Properties=Excel 8.0;Persist Security Info=False"


Any helping hands will be great

Priyesh



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!