How to convert PDF data to database table in SQL server

• pietlinden

  SSC Guru

  Points: 63584

  More actions

  December 4, 2023 at 9:14 pm

  #4339743

  If I just use a PowerQuery inside my data flow, I can just read the table and tell PowerQuery to ignore the rest. Then it's stupid easy. No need to use Excel at all.

• skeleton567

  SSCertifiable

  Points: 5903

  More actions

  December 4, 2023 at 10:30 pm

  #4339776

  Emperor100 wrote:

  First convert the PDF to excel format. Remove any unwanted lines, rows or any characters. Verify the data is correctly formatted, then save it as .csv file.  Use import/export wizard to import the data to SQL Server table.

  I'll try that and see what happens.  The challenge will be getting the 776 pages done in my lifetime!

  Rick
  Disaster Recovery = Backup ( Backup ( Your Backup ) )

• pietlinden

  SSC Guru

  Points: 63584

  More actions

  December 5, 2023 at 1:46 am

  #4339849

  If your data is in tables in the PDF file, you can tell PowerQuery to return just the table. Is this a publicly available PDF file? (likely not)... I wanted to see if I could get PowerQuery to read it and then maybe dump that into a table.

  (I have sooo wished for a PowerQuery transform in SSIS since forever.. so I could read from a PDF or whatever, and then send the data anywhere I want... Oh right, PYTHON.