Top "Oledb" questions

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft for accessing data from a variety of sources in a uniform manner.

Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

I created a windows application developed in .NET 3.5 in a 32 bit Windows 2008 server. When deployed the application in a 64 bit …

c# .net oledb 32bit-64bit jet
"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" Error in importing process of xlsx to a sql server

I have a 64 bit windows 7 and SQLServer 2008 R2 (64 bit) I follow the instructions that are here to import excel file …

sql-server-2008 excel oledb
Microsoft.ACE.OLEDB.12.0 provider is not registered

I have a Visual Studio 2008 solution with two projects (a Word-Template project and a VB.Net console application for testing). …

visual-studio ms-access ado.net oledb
what is the difference between OLE DB and ODBC data sources?

I was reading a MS Excel help article about pivotcache and wonder what they mean by OLE DB and ODBC …

odbc oledb
'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS …

sql-server excel ssis oledb aceoledb
Optimal way to Read an Excel file (.xls/.xlsx)

I know that there are different ways to read an Excel file: Iterop Oledb Open Xml SDK Compatibility is not …

c# excel oledb openxml-sdk excel-interop
How to import an Excel file into SQL Server?

I have data in an Excel file - actually xlsx format since it is now 2020. My requirement is to get …

sql-server excel csv import oledb
Using Excel OleDb to get sheet names IN SHEET ORDER

I'm using OleDb to read from an excel workbook with many sheets. I need to read the sheet names, but …

c# excel oledb server-side
How can I export data to an Excel file

I have an Excel file with data in it. I want to write some specific rows of it to another …

c# file export oledb
how to resolve DTS_E_OLEDBERROR. in ssis

In an ssis package consists of data flow task,contains OLEDB source and OLDB Target ..provider is sql native client..…

sql-server ado.net oledb ssis