Splitbits

In theory, there is no difference between theory and practice. But, in practice, there is

Splitbits

In theory, there is no difference between theory and practice. But, in practice, there is

OleDB

20 Jul 2009 on OleDB, Software Development, .NET

.NET, OleDB and Excel

OleDB is a very useful API in .NET, especially when manipulating the data in an Excel spreadsheet. In fact, it can open an Excel spreadsheet and query the data using regular SQL statements. using System.Data.OleDb; OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=…