repl.it
@PackDaddy/

Stevo's second repl

Python 2.7

Trying to interface with microsoft access file

fork
loading
Files
  • main.py
  • Packager files
  • requirements.txt
main.py
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)