How to add excelfile in resources, retrieve data from them

Hi, try the solution in the posts below,
http://stackoverflow.com/questions/15793442/how-to-read-data-from-excel-file-using-c-sharp
http://stackoverflow.com/questions/1426735/using-net-to-get-data-from-excel-as-a-database
http://support.microsoft.com/kb/316934

also you could try the third party excel .net component, hope it helps,
thank you

Thanks for reply,

i Write Complete Connection string.
Bu i want to merge excel sheet with EXE when i publish.
so no anyone can see excel file.

Vasu, Your question contains your answer. You are not providing the connection String.

You can transfer your Project/Application from one system to another system along with it's database but on that system also you need to store it on any drive otherwise your connection string will start showing you error message. Understand it in this way:- "You have a car, for driving it you need to refuel it otherwise it will not be working, ya there is one way to drive it and that's by pushing it from behind." similarly if you don't save your database then you will not be able to fetch data from it, ya there is one way to get data and that's by writing by yourself.