Stack Overflow
Stack Overflow

Questions tagged [aceoledb]

[Microsoft.ACE.OLEDB.12.0 data provider]: Used by Microsoft Access And as an integrated and improved ACE engine whose development started by taking a code snapshot of the original JET code base and upgraded to support 64-bit version and to enhance the integration with SharePoint related technologies and Web services generally.

Prior to Access 2007, Access used theMicrosoft Joint Engine Technology (JET)` engine. However, with Access 2007 release the JET engine was deprecated and is no longer distributed with MDAC. Instead, Access now uses an integrated and improved ACE engine whose development started by taking a code snapshot of the original JET code base.

The ACE engine is fully backward-compatible with previous versions of the JET engine so that it reads and writes (.mdb) files from earlier Access versions. Because the Access team now owns the engine, developers can be confident that their Access solutions will not only continue to work in the future but will also be faster, more robust, and feature rich. For example, with Access 2010 release, among other improvements, the ACE engine was upgraded to support 64-bit version and to enhance the integration with SharePoint related technologies and Web services generally. Microsoft is committed to Access as a developer platform.

48 questions
567
votes
39 answers

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I…
Shailesh Sahu
  • 5,801
  • 5
  • 18
  • 9
209
votes
11 answers

'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 package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data) It is not the same version I think some other…
Suhail Abdul Rehman Chougule
  • 2,369
  • 2
  • 12
  • 23
6
votes
3 answers

SSIS and 64-bit Microsoft Access Database Engine

Our dev server has SQL Server 2008 R2 64-bit with SSIS. In order to be able to import XLSX files directly from T-SQL (via OPENROWSET), we installed on the dev server the Microsoft Access Database Engine Redistributable 64-bit. The server already has…
Steve
  • 79
  • 7
4
votes
1 answer

Not all rows are imported from Excel file using OPENROWSET in SQL Server

I have a Excel table with 47 columns and 14K rows. I import this data to SQL Server with OPENROWSET: INSERT INTO dbo.my_table SELECT * FROM OPENROWSET ( 'Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;HDR=Yes;Database=C:\ExcelFile.xlsx', 'SELECT…
JohnyL
  • 6,894
  • 3
  • 22
  • 41
3
votes
1 answer

Get only specific columns from Excel (ACE OLEDB)

I am using ACE OLEDB to load an excel file into a DataTable. I have a list of the columns I need to grab from the file (column names). Problem is I couldn't find any working source on how to get only those specific columns from the Excel into the…
Cătălin Rădoi
  • 1,804
  • 23
  • 43
3
votes
1 answer

Microsoft ACE OLEDB 12.0 - F1 syntax for headerless .CSV causes exception

I am switching from using the 'Microsoft.Jet.OLEDB.4.0' provider to 'Microsoft.ACE.OLEDB.12.0' as I am launching my program on a 64-bit system, and I understand ACE has superseded Jet for 64-bit use. I haven't changed the syntax of the query I pass…
James Rowlinson
  • 31
  • 4
3
votes
1 answer

Openrowset function failure

I'm executing this openrowset function: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\Users\JCPABALAN\Desktop\Data Migration\ListOfDiscards.xlsx;HDR=YES', 'SELECT * FROM [Sheet1$]') But it gave me the…
user3709209
  • 61
  • 2
  • 10
3
votes
0 answers

How to set custom OleDb connection properties in ADO.NET?

In COM ADO you can use the Properties collection to set custom properties on a Connection, even after the connection is opened. Is there any equivalent for ADO.NET? I need this to do some operations on an Access database. The ACE OleDb provider…
Joshua Honig
  • 12,925
  • 8
  • 53
  • 75
2
votes
0 answers

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered

I am trying to import an Excel file into SQL Server for that I decided to use OPENROWSET. I have done below steps: Step 1:- sp_configure 'show advanced options', 1; RECONFIGURE; GO sp_configure 'Ad Hoc Distributed Queries',…
Sree
  • 101
  • 3
  • 10
2
votes
1 answer

Why is Access Database Engine giving a weird error?

The following code crashes with this error: System.Data.OleDb.OleDbException: 'Too few parameters. Expected 1' Dim selectString As String = "SELECT * FROM Products WHERE id = ?;" Dim cmd As OleDbCommand = New OleDbCommand(selectString,…
Jza
  • 21
  • 1
2
votes
1 answer

Two programs trying to read excel one succeeds one fails with same code

I have two programs unrelated to each other but they have an identical method where they try to read lines from an excel file. Program 1 public DataTable GetExcelInfo(string filepath) { DataTable datatab = new DataTable(); …
Kostas Balis
  • 122
  • 11
2
votes
1 answer

How to distribute an application that uses Microsoft Access database

I have created an application using Microsoft Access as the database. When I distribute it I get an error: "ACE.OLEDB.12.0" provider is not registered on the local machine" After searching I found a standard fix installing both 2007 Office…
user1072357
2
votes
2 answers

Alternative to ACE.OLEDB.12 for querying Excel data tables

I am currently using ACE.OLEDB.12 for querying Excel data tables and I encountered a limitation with the provider that is frustrating. The provider can only address the first 256 columns and 65536 rows so if I position any of my data tables outside…
Dimitris
  • 2,030
  • 3
  • 27
  • 45
2
votes
5 answers

Microsoft ACE OLEDB connection creating empty Excel when there are 166,110 rows

I am programming in C# and using an oledbconnection. This is the standard connection string e.g. using (OleDbConnection conn = new OleDbConnection( "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + saveFilenameAndLocation + …
Eloise
  • 21
  • 1
  • 3
1
vote
0 answers

SSIS package with multiple Excel Connection not working via SQL Agent Job

I have a SSIS package with 6 DFT's .Each DFT having connection to EXCEL (connection string -Provider=Microsoft.ACE.OLEDB.16.0;Data Source=ABC:\xyx.xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES";) as source and sql server as destination.I have…
Vlogs Bengali
  • 85
  • 1
  • 13
1
2 3 4