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
_______________________________________________
Python-ideas mailing list
Python-ideas@python.org
https://mail.python.org/mailman/listinfo/python-ideas
Code of Conduct: http://python.org/psf/codeofconduct/
