Download 2007 Office System Driver: Data Connectivity Components from Official Microsoft Download Center

2

File Name:

AccessDatabaseEngine.exe

10/3/2008

File Size:

25.3 MB

As a general replacement for Jet (If you need a general replacement for Jet you should use SQL Server Express Edition).
As a replacement for the Jet OLEDB Provider in server-side applications.
As a general word processing, spreadsheet or database management system; to be used as a way to create files. (You can use Microsoft Office to create the files that Microsoft Office supports, or use development tools to create Office OpenXML compatible files.)
To be used by a system service or server-side program where the code will run under a system account, or will deal with multiple users identities concurrently, or is highly reentrant and expects stateless behavior. Examples would include a program that is run from task scheduler when no user is logged in, or a program called from server-side web application such as ASP.NET, or a distributed component running under COM+ services.

Supported Operating System

Windows 7, Windows Server 2003, Windows Server 2008, Windows Vista, Windows XP

This download works with the following Office program:
- 2007 Microsoft Office system

To install this download:

Download the file by clicking the Download button (above) and saving the file to your hard disk.
Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
Follow the instructions on the screen to complete the installation.

To use this download:

If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”.

If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:

File Type (extension)       Extended Properties
---------------------------------------------------------------------------------------------
Excel 97-2003 Workbook (.xls)    "Excel 8.0"
Excel 2007 Workbook (.xlsx)       "Excel 12.0 Xml"
Excel 2007 Macro-enabled workbook (.xlsm) "Excel 12.0 Macro"
Excel 2007 Non-XML binary workbook (.xlsb) "Excel 12.0"
If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”

To remove this download:

AccessDatabaseEngine.exe

On the Start menu, point to Settings and then click Control Panel.
Double-click Add/Remove Programs.
In the list of currently installed programs, select “Microsoft Office Access database engine 2007” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
Click Yes or OK to confirm that you want to remove the program.

Desktop applications which read from and write to various files formats including Microsoft Office Access, Microsoft Office Excel and text files.
To transfer data between supported file formats and a database repository, such as SQL Server. For example, to transfer data from an Excel workbook into SQL Server using the SQL Server Import and Export Wizard or SQL Server Integration Services (provided the SSIS jobs run in the context of a logged-on user with a valid HKEY_CURRENT_USER registry hive).

2007 Office System Driver: Data Connectivity Components