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 vote233 views1 answer
Gets an existing SparkSession or, if there is no existing one, creates a new one based on the options set in this builder
Python
42 votes221 views6 answers
Train test split pandas
Python
0 vote243 views2 answers
How to draw a bar graph in python
Python
3 votes241 views1 answer
Python get day name
Python
0 vote239 views3 answers
Java random 6 digit number
Python
31 votes226 views1 answer
UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 6148: character maps to <undefined>
Python
11 votes218 views4 answers
Length of string python
Python
18 votes230 views4 answers
Python flatten a list of lists
Python
0 vote247 views1 answer
Solidity compiler for python
Python
13 votes209 views5 answers
How to create role discord.py
Python