excel

In business applications very often have the functionality of the import / Export data from / do Excel. One way to retrieve data from Excel is to use OLE DB as a data provider. It’s not the most optimal solution, but sometimes it is not possible to influence its choice. In order to take advantage of this method to define the connection string. And here there is a problem because in order to work this way, Excel must be installed. In addition, the definition of the connection string depends on the version of Excel installed on your computer. Both of [...]