[Python-ideas] need python automation code convert MDB files into csv files.

vinoth A N anvinoth7 at gmail.com
Mon Feb 4 19:10:30 EST 2019

Hello Friends,

I am in process of writing python automation code through which I can read 
the MDB file which contains several tables which need to convert them in 
multiple CSV file or xlsx file.

## package required 
import pandas as pd
import numpy as np
import os
import glob
from functools import reduce

# to know how many csv file and name csv file in current floder
os.chdir('C:\\Users\\anvinoth\\Desktop\\BODOPD\\DXA_C2') # code to change 
working directory
extension = 'mdb'
result = [i for i in glob.glob('*.{}'.format(extension))]


import pandas_access as mdb
# Listing the tables.
for tbl in mdb.list_tables('FB4-DXA-C2-BSL.mdb'):

# Read a small table.
df =mdb.read_table('FB4-DXA-C2-BSL.mdb', "Patient")

i am getting this error

WinError 2] The system cannot find the file specified

I am searching in google but I did not find a relevant answer

could anyone in the group help me out with correct code to convert the 
MDB file into CSV file?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-ideas/attachments/20190204/9c9d4cdf/attachment.html>

More information about the Python-ideas mailing list