How to import PDF file to SQL Server table

Recently I had to import a PFD file to SQL Server database. The file contained some statistical information in the form of tables and numbers.

Here is a simple way of doing this:


  1. Open the PDF file in Acrobat Reader (I used version 9.1)
  2. Click on Save As…
  3. Save the document as Text (Accessible) .txt
  4. Write a SSIS package which follows the convention of your file, or copy and paste the data to Excel and the import it to SQL Server


I thought I’d share this, since I didn’t find information about it in the online searches.



Comments are closed.