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!