Excel Data Provider Excel Spreadsheet Integration with Visual Studio LightSwitch
The Excel Data Provider for ADO.NET gives developers the power to easily connect applications with real-time data from spreadsheets stored in Microsoft Excel The Excel Data Provider makes these Excel Spreadsheets look like SQL tables in your applications. With the Excel Data Provider for ADO.NET developers can simply DataBind to data, just like using SQL Server. 1-2-3 Easy Steps to Excel Spreadsheet IntegrationConnecting .NET applications to Excel has never been easier. The Excel Spreadsheet Data Provider offers complete read-write access to Excel Spreadsheets, through an easy to use Data Provider interface that every .NET developer is familiar with.
The Excel Data Provider effectively makes Excel Spreadsheets look exactly like a database to your applications. If you want to integrate your applications with Excel and you have ever written Transact-SQL, then Excel Data Provider is definitely for you! |