How can I insert values from pdf to sql

Answer 1

That's a very broad question -- the most important problem here is parsing the pdf file. Do you know the format of it? Is it constant? Is it a scan or a text file of some structure? What structure?

Having answered all those questions above only then can you move on to putting the values to SQL, which, compared to the text mining task, will be a 🍰

Answer 2

Oh, this *matters a lot* what kind of format the file is...

Pandas module contains powerful methods for reading txt files. But only if you are sure they are correct and well structured.

For advanced parsing of PDF files you will need an external module like PDFMiner or PyPDF.

Answer 3

If it's a one time task, I usually load the text file to SublimeText, using Search and Replace with regular expressions, turn it into a bunch of insert statements, and run it as a script.
If this job must be done repeatedly by the users, I usually write a GUI program.

Answer 4

It's a text file not scan. It doesn't matter insert from PDF or *.docx It also can be a *.txt file.