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

[vinoth A N]

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))]
print(result)

['FB4-DXA-C2-BSL.mdb']



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


# 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?
 
thanks
vinoth


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