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

0 vote171 views1 answer
Get unique words from pandas dataframe
Python
2 votes180 views2 answers
Python split string capital letters
Python
25 votes124 views7 answers
Remove space from start and end of string in python
Python
13 votes189 views5 answers
Binary tree in python
Python
1 vote171 views2 answers
Python pandas remove punctuation
Python
91 votes168 views4 answers
String remove last 3 characters python
Python
0 vote162 views1 answer
How to deploy a file size greater than 100mb on pythonanywhere
Python
0 vote164 views1 answer
How draw shell in python
Python
0 vote161 views1 answer
Add up the elements in this RDD
Python
0 vote153 views1 answer
Add Cog to bot in Discord.py
Python