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.