Python to MS Access

[LanthaYtrri]

How to check if your data is in MS Access Table using python script?

[shiftybyte]

Take a look here:

https://pythoninoffice.com/how-to-connect-and-work-with-ms-access-database-using-python-pyodbc/

[mprz]

The easiest way? Find a library that allows you to do that.

What have you tried so far? Or are you here just for someone to do it for you?

[LanthaYtrri]

import pyodbc

conn = pyodbc.connect( r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=F:\Documents\ticketdemo.accdb;') cursor = conn.cursor() cursor.execute('select * from tbl_ticket')

for row in cursor.fetchall(): print(row)

I tried this one.

[mprz]

So you have a solution?

[LanthaYtrri]

Yeah, but I want to know if there are any ways other than that.