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
1
vote
1 answer

Why use .xlsx (Microsoft Excel 2016/2013/2010) file for data import instead of saving .xlsx as .xls(Microsoft Excel 97-2003)?

/* This question is informational. I had to post it as question since I couldn't comment under others' replies to the questions associated with 3 errors below. These errors occurs in SSIS and SQL Server Import and Export wizard. */ The…
pavnis
  • 39
  • 7
1
vote
0 answers

How to read HTML files with ACE.OLEDB.12.0

I was trying to read .xls files with Microsoft.ACE.OLEDB.12.0. I could able to read some of the files but some of them turned out to be html files with .xls extension and throw this error: "External table is not in the expected format." These HTML…
sevenkul
  • 966
  • 1
  • 8
  • 14
1
vote
2 answers

ACE Oledb 12.0 and XLSX problems

I'm using the following code to set a connection string on my local PC that has Office 2007, SQL Server 2008: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + MapPath(Request.ApplicationPath) + "\\" + excelFolderName + fileName…
RedEagle
  • 4,418
  • 9
  • 41
  • 64
1
vote
1 answer

Excel ACE.OLEDB: COUNTIF equivalent in query

I developed the following Microsoft Query in ACE.OLEDB: SELECT Name, Country (SELECT COUNT(*) FROM Table1 as T1 WHERE Name = T.Name AND Country = T.Country AND Description="Work" GROUP BY Name, Country) /…
AnalystCave.com
  • 4,884
  • 2
  • 22
  • 30
1
vote
0 answers

Import Excel Sheet into SQL Server 2012

I am presently doing migration of SQL Server 2005 to SQL Server 2012. Mostly all the functionality remains the same. However, in few store I was using Jet provider 4.0 to import Excel data into the SQL Server table. I know it is not being supported…
user3721199
  • 49
  • 3
  • 13
1
vote
1 answer

Microsoft ACE OleDB : Could not find file on release version

I am reading .dbf files using Microsoft ACE OLEDB. I always get the following error when I try to release the application: path name : could not find file. However, the process works on the local version. Here is my connection…
greenymaster69
  • 1,366
  • 1
  • 10
  • 18
1
vote
0 answers

How to read an Excel file in 64bit OS using ACE OLEDB provider?

I have a c# application that I have moved to a 64bit machine. This application reads in an Excel file for some data input. I would like to build this project as 64-bit. Is there any way to have my program read in this file? I find it hard to believe…
user1750548
  • 11
  • 2
0
votes
0 answers

Microsoft ACE OLEDB connection creating filter like use "Excel.Application"

Can I make filter in created excel? This is the standard connection string e.g. I create file Excel and save to disk ConnectionString= " |Provider=Microsoft.ACE.OLEDB.12.0; |Data Source="+NameExcel+"; |Extended Properties=""Excel…
Boris
  • 43
  • 7
0
votes
0 answers

VS C# application - faster in Studio than on Different Comp

Odd question - I know - be gentle - first post. Did a bunch of searching, and maybe I'm just using the wrong search terms. I've got a VS C# app that I run from the development environment (poor form - I get it, but, I do.) When a different user (on…
mw42
  • 37
  • 6
0
votes
2 answers

Import from excel error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

i try to use ms interopt to import data from excel file, i have install Microsoft office 2007 in my computer and working fine, when i use the code in another computer have Microsoft office 2019 installed i face this error, i install Microsoft…
Fath Bakri
  • 161
  • 1
  • 12
0
votes
1 answer

Microsoft.ACE.OLEDB.16.0 upgrade SSIS Unexpected termination

We have SSIS package installed in SSIS catalog server. In the catalog server, Microsoft.ACE.OLEDB.12.0 is installed. The jobs were running fine without issues. We are importing into Excel Template. Our connection string looks like…
Venkataraman R
  • 12,181
  • 2
  • 31
  • 58
0
votes
1 answer

External Table not in expected format open xml

I am trying to upload an excel(.xlsx) file in my application which has been created by the same application via open xml sdk. I am facing the exception 'External table not in expected format'. However if i manually open the file and save it and try…
subhrendu
  • 147
  • 1
  • 2
  • 19
0
votes
0 answers

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER converting XLS to TXT

I started a new job with a brand new laptop and vanilla environment. I have installed Visual Studio and I'm trying to convert a XLS file to TXT. This is my Control Flow: And this is my Data Flow: When I run the package I incur in the notorious…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
0
votes
1 answer

SSIS job failing with error “The step did not generate any output. The return value was unknown. The process exit code was -529697949. ”

I have a SSIS Package which has a simple dataflow with Excel to Excel data transfer. I am using Microsoft.ACE.OLEDB 12.0 driver for connection. Now in my development machine it is running fine through packages. But when I deploy and ran it via SQl…
Vlogs Bengali
  • 85
  • 1
  • 13
0
votes
1 answer

System.AccessViolationException occurs with MS Access databases just over WiFi connection

I'm developing a desktop application for my company (it's just a prototype, actually) for bringing simple services to production department (tool and process instructions, presence records, product traceability, etc). I'm using VB.net and wpf; some…
IFrank
  • 419
  • 1
  • 5
  • 12
1
2
3 4