1
this is the provider settings or sqlconnection settings for ms excel once we complete this every this is common like sqlcommand,dataset,dataadapter
sqlconnection con= new sqlconnectio(provider=Microsoft.Jet.OLEDB.4.0;Data
Source='Your Filename';Extended Properties=Excel 8.0;)
,but select statement is sytanx is some differ like this way
ample Select sql
sqlcommand cmd = new sqlcommand("select * from [Sheet1$] where condition",con);
if it satisfies you accept this answer by clicking thumb up symbol
0
Hi chiranjeevi,
This is a simple application i did of your requirements.Run the attachments.
Thanks
If it helps you plz mark the answer as Accepted answer
0
Also look at the articles in this web site about Excel.