Using Python to extract data from MS Access

Question

I need to extract a table from Access and print it in python. I have successfully connected the Access data base but I am not sure how to pull the table from Access and move it into a python data frame. I have inserted my code below.

odbc_conn_str = 'DRIVER={Microsoft Access Driver (*.mdb, 
*.accdb)};DBQ=%s;UID=%s;PWD=%s' % (db_file, user, password)
conn = pyodbc.connect(odbc_conn_str)
cur = conn.cursor()
SQLCommand = 'select *from table1'

df = cur.execute(SQLCommand)
print(df)
conn.commit()

I get no errors but all this returns is

<pyodbc.Cursor object at 0x0BCFF3A0>

try fetchall() command

bilbo_strikes_back
– bilbo_strikes_back

2017-06-27 15:59:36 +00:00
Commented Jun 27, 2017 at 15:59 — bilbo_strikes_back
– bilbo_strikes_back, Commented Jun 27, 2017 at 15:59

bilbo_strikes_back · Accepted Answer · 2017-06-27 16:05:00Z

2

The fetchall() will retrieve the result

odbc_conn_str = 'DRIVER={Microsoft Access Driver (*.mdb, 
*.accdb)};DBQ=%s;UID=%s;PWD=%s' % (db_file, user, password)
conn = pyodbc.connect(odbc_conn_str)
cur = conn.cursor()
SQLCommand = 'select * from table1'
cur.execute(SQLCommand)
df = cur.fetchall()
print(df)

You don't need to commit a select statement

answered Jun 27, 2017 at 16:05

bilbo_strikes_back

5913 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Python to extract data from MS Access

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related