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

46 votes129 views4 answers
How to get the type of a variable in python
Python
0 vote121 views1 answer
List tuple dictionary,
Python
5 votes130 views2 answers
Code challenges python
Python
-1 vote128 views2 answers
Python choose function
Python
82 votes132 views6 answers
Activate python venv in windows
Python
0 vote96 views1 answer
Count number of pages in pdf python pdfminer
Python
1 vote138 views1 answer
Create period pandas
Python
-2 votes152 views3 answers
Pyhton
Python
2 votes136 views2 answers
Python convert hex to binary
Python
0 vote127 views1 answer
Read .fasta python
Python