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.

Scientific notation when importing from Excel in .Net

I have a C#/.Net job that imports data from Excel and then processes it. Our client drops off the …

c# .net excel oledb
Any references/manuals on SQL in EXCEL with Microsoft OLE DB Provider for Jet 4.0?

is there any references/manuals on SQL syntax in EXCEL connected with Microsoft OLE DB Provider for Jet 4.0 ? For example, …

sql excel oledb
'Microsoft.ACE.OLEDB.12.0' provider is not registered -but it is

Short and sweet: app works on x86 machine but not on x64 (tried on a 2008 Server and a Windows 8) Microsoft …

ms-access 64-bit oledb oledbconnection
OLEDB, Writing Excel cell without leading apostrophe

I'm writing to Excel file using OLEDB (C#). What I need is just RAW data format. I've noticed all cells (…

c# .net excel oledb apostrophe
When should I be using Odbc, OleDb, SQLClient? What are the trade-offs

I am starting off with a SQLServer database. So it would seem that I should use System.Data.SqlClient namespace. …

.net database odbc oledb sqlclient
Reading Excel InterMixed DataType Without Modifying Registry Key

I am trying to use C# to read excel file which has intermixed datatype. Below is my connection string var …

c# excel registry oledb registrykey
OleDbConnection gets "External component has thrown an exception."

I' m using a Windows Forms application to export data to excel. Application is built both x64 and x86. So …

c# oledb oledbconnection
Ms Access: Record(s) cannot be read; no read permission on [table]

i wrote script for downloading mdb files and reading them due OLEDB provider. All works fine, but if i try …

ms-access permissions oledb database-permissions
Read a big Excel document

I want to know what is the fastest way to read cells in Excel. I have an Excel file that …

c# excel datatable oledb
DBNull in non-empty cell when reading Excel file through OleDB

I use OleDB to read an Excel file. One of the columns has a "Common" format and contains both strings …

c# excel oledb dbnull