Top "Oledb" questions

How do I query raw data from a Proficy Historian?

How can I retrieve raw time-series data from a Proficy Historian/iHistorian? Ideally, I would ask for data for a …

c# oledb proficy historian

How to get a list of installed OLE DB providers?

Microsoft Excel allows import of data from "Other Sources". One of the options is to use an OLE DB provider. …

excel ms-office oledb

OleDB not supported in 64bit mode?

I've been using Microsoft.Jet.OLEDB.4.0 and Microsoft.ACE.OLEDB.12.0 to read in .csv, .xls, and .xlsx files. I just …

c# .net csv 64-bit oledb

OPENROWSET with Excel file

I want to execute simple statement: SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\Temp\;','SELECT * FROM […

sql-server sql-server-2008 excel oledb openrowset

Microsoft.Jet.OLEDB.4.0 - Provider can not be found or it may not be installed

I have created an Excel Macro in which I have used Microsoft.Jet.OLEDB.4.0 to fire query on Excel work …

vba excel oledb jet

How to upload only non-empty rows of Excel spreadsheet using oledb in C#?

I am importing excel sheet to DataTable using oledb connection as below. private static DataTable UploadExcelSheet(string fileName) { DataTable uploadDataTable; …

c# excel oledb

Accessing Excel Spreadsheet with C# occasionally returns blank value for some cells

I need to access an excel spreadsheet and insert the data from the spreadsheet into a SQL Database. However the …

c# excel visual-studio-2008 oledb

ACE OLEDB "External table is not in the expected format" with large text in Excel cell

I'm trying to read an .xls file that happens to have a very large text cell (around 8900 chars) using System.…

c# excel oledb ms-jet-ace

How to SELECT from any spreadsheet in Excel File using OleDbDataAdapter

I'm using OleDbDataAdapter to extract DataSet from excel file, but I have problems with SELECT statement inside DataSet excelDataSet = new …

c# excel linq oledb oledbdataadapter

Sql error "Arithmetic operation resulted in an overflow."

I am running a service that does some computation and communicates with an ms sql server every minute or so (24/7, …

c# sql sql-server oledb oledbexception