Post reply

Moving data from PDF files to SQL Server DB

  • March 22, 2005 at 6:40 pm

    #68803

    Hi,

    I am working on a data Integration project which requires me to  transfer data from .xls and  .pdf files to SQL server DB. I could load data from xls using DTS but i havent figured out  a way to transfer data from pdf files. Any ideas?

    Thanks in Advance,

    Adi

  • March 24, 2005 at 3:04 am

    #548682

    you could store the pdf in a blob field. and have a 2nd field that contains keywords, (although these would need to be manually keyed) and then create a full text index on this field.

     

      - Alex

     

  • March 27, 2005 at 5:26 pm

    #549076

    Hi Alex,

    Thanks for replying. Can you elaborate more about the solution you proposed? I have to load  tabular data from  PDF file into DB tables. Is there any way of reading Column headers and  then indiviual rows from a PDF. This is how i am loading data from XLS file into the table.

    -Adi

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply