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

3 votes76 views1 answer
Parquet to csv
Python
3 votes127 views3 answers
Python create dictionary from csv
Python
0 vote135 views1 answer
What is the correct way to sort the list 'B' using a method, the result should not return a new list, just change the list 'B' in python
Python
0 vote141 views1 answer
Using built-in crawlers is very simple. A minimal example is shown as follows.
Python
0 vote132 views1 answer
Python bangla packages
Python
0 vote142 views1 answer
Local to ISO 8601 without microsecond:
Python
0 vote131 views1 answer
Expand pandas dataframe into separate rows
Python
0 vote123 views1 answer
Python Multiline docstring example
Python
15 votes127 views3 answers
Clear window python console
Python
0 vote136 views1 answer
Relative text size put text cv2
Python