Python odbc access database

import pyodbc

conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path where you stored the Access file\file name.accdb;')
cursor = conn.cursor()
cursor.execute('select * from table name')
   
for row in cursor.fetchall():
    print (row)

Source: datatofish.com

Similar codes

20 votes277 views6 answers
Python last item in list
Python
0 vote313 views1 answer
How to access value from <class 'pandas.core.indexes.numeric.Int64Index'>
Python
1 vote360 views1 answer
[0] * 10 python
Python
0 vote354 views1 answer
Else if in django template
Python Django
0 vote290 views1 answer
Tuple and dictionary in python
Python
7 votes357 views2 answers
Create the dataframe column based on condition
Python
3 votes295 views1 answer
Parquet to csv
Python
0 vote321 views1 answer
Create array with unknown size in python
Python
0 vote360 views1 answer
Django form label in template
Python Django
13 votes308 views4 answers
Pandas list to df
Python