I have a database built in Access that contains a free-text field. This database resides on a PC. My Python program would be on the same PC. I was hoping to use Python to retrieve content from the free-text field and search for key terms using NLP. If the key terms are present, Python will gather data from other fields (name, ID number, etc) within the same table and send an alert via email.
The imported module pySQLite seems pretty straight forward. Does anyone know an easier way to get this done with Python?