• Confusing Queries (3/23/2014)


    Hi everyone,

    We are facing a problem with loading data text from .pdf files[/url] from vendor.

    .pdf files have data in tabular format and we would like to insert those fields into a SQL table.

    We do not want to insert the physical location of the file but, we need to insert the data within the file.

    How can we read a pdf file[/url]?

    Thanks & Regards

    If you want to read a pdf file, I think you might use some PDF reading utility. And as for this question, I think you can find answer in this post.

    http://www.sqlservercentral.com/Forums/Topic1339455-148-1.aspx

    As for "you want to insert data filed that is in tabular format into SQL table", maybe you can check this post

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/01bf1171-6165-4c29-9242-d7f11f9662d3/insert-pdf-fields-into-sql-table?forum=sqlintegrationservices

    Hope it offers some useful help.:-D