Python : Code to search a value inside a database (.mdb)

Job ID: 36914713

Budget: €8 – €30 EUR

Hello,

I need a code to search value inside a database(.mdb). its a database access with a lot of tables and columns.

I need to have an algoritm that search a value . The algorithm have an option : exact or contain
when the option exact is activated:
i need to have inside the value exactly the value that i search

when the option "contains" is activated i need to have the values that contains the word that iseach



the output of this algoirthm its a CSV file:
i need to have the table, the columns and the row where i have the value. and the value and the option used inside the algorithm( exact or contains)

if i have multiple results i want to have all results

so we have 4 columns :
table
columns
row
value
Option search


i cant send you a database but you can create it on microsoft access quicly to test

i use the connector of pyodbc to acces to the base inside python (microsoft access driver)
Related categories: Python Microsoft Access