Top "Oledbconnection" questions

How to read .xlsx and .xls files using C# and OleDbConnection?

Previously I was using ExcelPackage to read data out of a .xlsx file. That was working fine but then I …

c# excel oledbconnection

"Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine" but I have it installed already

I have the same problem as others but (in this case) I have already installed that component. UPDATE: I have …

asp.net oledb oledbconnection oledbexception

How to set database name as a variable in SSIS?

In my current project, the database name keeps changing and I do not want to modify my OLE DB Sources …

variables ssis oledbconnection

Export into excel file without headers c# using Oledb

I'm using OleDB and I want to export my objects into excel table. Each row in the sheet will be …

c# oledb oledbconnection oledbcommand

Dynamic OLEDB Connections in SSIS

I am designing a SSIS package which imports data from one data base to other database. In reality I need …

dynamic ssis oledbconnection

System.Data.OleDb.OleDbConnectionInternal..ctor: Unspecified error

After several hours (~6 hours Win7 64bit, ~24hours WinXP) of running multi-threaded (.NET Framework 3.5 SP1 WinForms) desktop application using .mdb files …

c# .net oledb oledbconnection

Obtaining First Excel Sheet Name With OleDbConnection

I have one problem. I need to get the excel sheet name in a work book, which looks on the …

excel oledbconnection

Can I read Excel files using the OleDbConnection Excel ACE Driver from a non-seekable System.IO.Stream rather than a file?

There's a similar question here In Memory OleDbConnection to Excel File but, this question was answered by avoiding it completely …

c# windows excel stream oledbconnection

"Unspecified error" while opening an ADODB connection

I am facing "Unspecified error" in only one PC of my users. Run-time error '-2147467259 (80004005)': Unspecified error I am …

excel vba ms-access adodb oledbconnection