Connecting to MS accdb and read data into Pandas

[MRAB]

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 could not connect to .accdb.
> 
> What is the robust way to set the connection string?
> 
What does the traceback say?