helo friends.
i need to deal with more than 10 excel sheets..
so i want to make an desktop application in Visual Studio(c#),
which performs as followings..:
1) first user can choose on which file he wants to work on.
2) then retrieving column wise data, and performing many mathematical calculation
on that data.
3) and all the result should be stored in another new excel sheet..
so can anybody tell me how can i connect all the excel sheets to my database??
This forum is for Classic ASP.
okay.. :(
HAI Dear,
Databases are great for storing information, but sometimes you want to use or analyze its data in Excel. You can use the Data Connection Wizard to create a dynamic connection between a SQL Server database and your Excel workbook. You get to the Data Connection Wizard through the Data tab.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.