Answer the question
In order to leave comments, you need to log in
How to link Access and Python?
Good day, tell me, please, I found on the Microsoft website a way to connect a python program to DB Access
import pyodbc as sqlMS
connStr = (
r"DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};"
r"DBQ=Q:\Шилов\Data Base\Documents.accdb;"
)
conn = sqlMS.connect(connStr)
Answer the question
In order to leave comments, you need to log in
Most likely you have 64 bit python and 32 bit access. Either install python x86 or access 64.
The best option is not to try to work with Access
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question