how to deal with .mdb access files with python

by

Below is some code I wrote for another SO question.
It requires the 3rd-party pyodbc module.

This very simple example will connect to a table and export the results to a file.
Feel free to expand upon your question with any more specific needs you might have.

import csv, pyodbc

# set up some constants
MDB = 'c:/path/to/my.mdb'
DRV = '{Microsoft Access Driver (*.mdb)}'
PWD = 'pw'

# connect to db
con = pyodbc.connect('DRIVER={};DBQ={};PWD={}'.format(DRV,MDB,PWD))
cur = con.cursor()

# run a query and get the results 
SQL = 'SELECT * FROM mytable;' # your query goes here
rows = cur.execute(SQL).fetchall()
cur.close()
con.close()

# you could change the mode from 'w' to 'a' (append) for any subsequent queries
with open('mytable.csv', 'w') as fou:
    csv_writer = csv.writer(fou) # default field-delimiter is ","
    csv_writer.writerows(rows)

More Related Contents:

  1. Working with an Access database in Python on non-Windows platform (Linux or Mac)
  2. What do I need to read Microsoft Access databases using Python?
  3. “Data source name not found and no default driver specified” with Access ODBC
  4. How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access
  5. Python run command till button is pressed
  6. How to read/process command line arguments?
  7. selenium.common.exceptions.InvalidSelectorException with “span:contains(‘string’)”
  8. How to reversibly store and load a Pandas dataframe to/from disk
  9. Histogram Matplotlib
  10. How to import a text file on AWS S3 into pandas without writing to disk
  11. numpy array dtype is coming as int32 by default in a windows 10 64 bit machine
  12. How to display a 3D plot of a 3D array isosurface in matplotlib mplot3D or similar?
  13. Tuple or list when using ‘in’ in an ‘if’ clause?
  14. How can I check that a list has one and only one truthy value?
  15. Deserialize a json string to an object in python
  16. Why does input() give a SyntaxError when I just press enter?
  17. pip install . creates only the dist-info not the package
  18. Implement list-like index access in Python
  19. Get all modules/packages used by a python project
  20. convert a grayscale image to a 3-channel image [duplicate]
  21. python tkinter how to bind key to a button
  22. Can anyone explain me StandardScaler?
  23. How to convert a set to a list in python?
  24. How to express classes on the axis of a heatmap in Seaborn
  25. re.search() only matches the first occurrence
  26. heatmap-like plot, but for categorical variables in seaborn
  27. How to get `setup.cfg` metadata at the command line (Python)
  28. Django Multiple Databases – relation does not exist; LINE 1: SELECT COUNT(*) AS “__count” FROM
  29. yaxis range display using absolute values rather than offset values
  30. Pandas: Selecting rows based on value counts of a particular column

Leave a Comment