How To Connect And Work With MS Access Database Using Python pyodbc

In this video we'll go through how to use Python to connect, query and make changes to the MS Access database. You can find text version of this tutorial here:

[chadjohnson]

This was a very helpful video and super intuitive I just want to say thank you for staying up till 1:00 a.m. to explain this so I don't have to! Much appreciated ❤️

[JeffreyFlaker]

Just a thought for any deletes you will perform. If you first do a Select, you can visually confirm that you will be deleting the right data.

Do Select....where....

If you are satisfied with the selected data, just change the statement from select to delete keeping the where.

I started doing this after accidentally losing a table full of data I was playing with. It is a good habit to get into.

The fact that you are using commits helps, but if you don't realize the selection, you can, out of habit or forgetfulness, execute a commit before you realize your mistake.

[irishRocker]

Very useful, thanks.
I wrote some python code to take in a log file and parse some info from it using pandas.
It turned out the log file had been exported from MS Access so I want to update it to work with the log file or access file as an input and this looks perfect to get the database into Pandas, and then the previous code should still work to parse the info in the table.

[srishtiaryavir]

Hi very helpful video! Just a small question, what if i want to export a different object than tables like an MS Access report . How can I do that?

[brandyxpx]

Hi, when I try to use pandas I get this error, any ideas? UserWarning: pandas only support SQLAlchemy ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy

[binduskumar]

Hi!, in the access file we have Query option.
How to select that object in python?

[sabaqamer]

My access is 32 bit and python is 64....they arent connecting..what to do/???

[computerdictionary]

form where i get the connection string

[highschoolboiiii]

how do i take the new table name as a input and create a new table??

[kingmaker]

sir pyodbc access database connect error pyodbc interface error default sql driver error access database connection issue

[mrjoshua]

I like this video, but I get an error ProgrammingError: ('The SQL contains 21 parameter markers, but 77 parameters were supplied', 'HY000') when I try to upload a dataframe to access. Not sure where I am going wrong.

[hendrik]

Modulenotfound: no Module named: „pyodbc“