creating masters in MSEXCEL and Provider for MsExcel.

[srivalli]

i developed a small project in vb.net using sqlserver 2000 as backend.

in that i created two master tables and one more table and in the third table ,i am retrieving the details of two master tables in each combobox

now i want to convert that whole project using msExcel as back end
so can i create masters tables in excel
and i want to know the correct provider for MsExcel

this question i already posted 2 to 3 times,but if i use that provider for msExcel ,it is showing some error

so i want to know can any one tell the correct provider used for MSEXcel
thanku

 

[jmcilhinney]

You use the same provider for Excel as you use for Access, i.e OleDb using Microsoft Jet 4.0. Excel is not a relational database, so the concept of master and detail tables does not really carry over properly. You can relate cells in worksheets but it is not really the same thing. Search for "ADO.NET Excel" on MSDN and you will find examples.