On 2021-10-12 09:40, Shaozhong SHI wrote:
I tried the following code:
import pyodbc
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb,
*.accdb)};DBQ=D:\my.accdb;')
cursor = conn.cursor()
cursor.execute('select * from table_name')
for row in cursor.fetchall():
print (row)
But
I tried the following code:
import pyodbc
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb,
*.accdb)};DBQ=D:\my.accdb;')
cursor = conn.cursor()
cursor.execute('select * from table_name')
for row in cursor.fetchall():
print (row)
But I could not connect to .accdb.
What is the