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:
- Open the PDF file in Acrobat Reader (I used version 9.1)
- Click on Save As…
- Save the document as Text (Accessible) .txt
- 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.