Migrate data from PDF file to MySQL

Question

I have a PDF file containing thousands of entries like userId,userName etc. Is there any way to insert these into a MySQL database?

Can you break this out into a CSV file? – tadman May 02 '16 at 07:46 — tadman, May 02 '16 at 07:46

score 1 · Answer 1 · edited May 23 '17 at 10:33

1

You Actually can not import data from a PDF file

An work around is to convert the file to an excel and importing from it

To convert pdf to excel

https://www.freepdfconvert.com/pdf-excel

To Import data from excel to Database

How to import an excel file in to a MySQL database

edited May 23 '17 at 10:33

Community

1
1

answered May 02 '16 at 07:52

Andrews B Anthony

1,381
9
27

score 0 · Answer 2 · answered Apr 07 '21 at 22:34

If it's a one-off file you can copy and paste the contents into excel, save as CSV and import into you mysql table.

You can also parse it, there's plenty of libraries to convert pdf data into text, which such text can be then further parsed and inserted into your table.

If you need to do it in mass, then I suggest get a mass converter like this pdf to mysql indexer, then parse the indexed data into structured content.

Migrate data from PDF file to MySQL

2 Answers2