|
Size: 1167
Comment:
|
Size: 1777
Comment: Remove underscore in page name
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| ## page was renamed from Microsoft_Access | |
| Line 2: | Line 3: |
= Microsoft Access mdb and accdb database = URL:: http://office.microsoft.com/en-us/access/ Licence:: Commercial/Proprietary software Platforms:: Windows |
= Microsoft Access mdb and accdb Database = URL:: http://office.microsoft.com/en-us/access/ Licence:: Commercial/Proprietary software Platforms:: Windows |
| Line 13: | Line 9: |
* Widely used database by end users. |
* Widely used by end users. |
| Line 18: | Line 13: |
| Line 24: | Line 18: |
=== pypyodbc （Pure Python) === URL:: http://code.google.com/p/pypyodbc |
=== PyPyODBC （Pure Python) === URL:: http://code.google.com/p/pypyodbc |
| Line 33: | Line 22: |
| Python versions:: 2.4 - 3.3 | Python versions:: 2.4 - 3.4 |
| Line 35: | Line 24: |
| PyPyODBC is a pure Python script module providing ODBC interfacing functions, it runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit. | |
| Line 36: | Line 26: |
| On Windows Platform, PyPyODBC provide a set of methods to bring [[https://code.google.com/p/pypyodbc/wiki/pypyodbc_for_access_mdb_file | PyPyODBC's extra support for Access on Windows Platform]] | However, '''''on Windows Platform''''', PyPyODBC also provides a set of methods bringing [[https://code.google.com/p/pypyodbc/wiki/pypyodbc_for_access_mdb_file|PyPyODBC's extra support for Access on Windows Platform]] |
| Line 38: | Line 28: |
| === mxODBC === URL:: http://www.egenix.com/ License:: eGenix.com Commercial License Platforms:: Windows, Unix Python versions:: 2.4 - 2.7 |
|
| Line 39: | Line 34: |
| PyPyODBC is a pure Python script, it runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit. | On Windows, you can use mxODBC with the ODBC driver that comes with MS Access, or use the ODBC driver that comes with the [[http://www.microsoft.com/downloads/details.aspx?familyid=78CAC895-EFC2-4F8E-A9E0-3A1AFBD5922E&displaylang=en|MDAC 2.8 SP1 database access package]], if you don't have MS Access installed on the machine. |
| Line 41: | Line 36: |
Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python ). Simple - the whole module is implemented in a single python script with less than 3000 lines. Built-in Access MDB file creation and compression functions on Windows. |
On Unix platforms, you can use one of the ODBC drivers available from commercial ODBC vendors. If you only need to query data from MS Access files, you can also have a look at the very limited ODBC driver that comes with the [[http://mdbtools.sourceforge.net/|MDBTools]]. This works reasonably well to extract data from the MS Access files. |
Microsoft Access mdb and accdb Database
- URL
- Licence
- Commercial/Proprietary software
- Platforms
- Windows
Pros
- Widely used by end users.
- It comes with the GUI tools,and very user friendly.
Cons
- Windows only.
DB API 2.0 Drivers
PyPyODBC （Pure Python)
- URL
- License
- MIT
- Platforms
- Windows, Linux
- Python versions
- 2.4 - 3.4
PyPyODBC is a pure Python script module providing ODBC interfacing functions, it runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit.
However, on Windows Platform, PyPyODBC also provides a set of methods bringing PyPyODBC's extra support for Access on Windows Platform
mxODBC
- URL
- License
- eGenix.com Commercial License
- Platforms
- Windows, Unix
- Python versions
- 2.4 - 2.7
On Windows, you can use mxODBC with the ODBC driver that comes with MS Access, or use the ODBC driver that comes with the MDAC 2.8 SP1 database access package, if you don't have MS Access installed on the machine.
On Unix platforms, you can use one of the ODBC drivers available from commercial ODBC vendors. If you only need to query data from MS Access files, you can also have a look at the very limited ODBC driver that comes with the MDBTools. This works reasonably well to extract data from the MS Access files.