1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
# import pyodbc
import os
path = r'C:\Users\stepac\Downloads'
for file in os.listdir(path):
if file.endswith(".mdb"):
print(os.path.join(path, file))
# conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\stepac\Downloads\Dunluce_SP.mdb;')
# cursor = conn.cursor()
# cursor.execute('select * from table BEDS')
# for row in cursor.fetchall():
# print (row)