SQLServerCentral.com / SQL Server 2014 / Development - SQL Server 2014 / Insert data from .pdf files / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 13:28:19 GMT20RE: Insert data from .pdf fileshttp://www.sqlservercentral.com/Forums/Topic1553798-3412-1.aspxOn a non-technical level, has anyone asked the vendor what other formats they can send the data in? PDF is a print format for humans; having a computer pull data out of it is less than ideal compared to getting a fixed width text file, a delimited text file, or a variety of other formats.Fri, 28 Mar 2014 11:45:07 GMTNadrekRE: Insert data from .pdf fileshttp://www.sqlservercentral.com/Forums/Topic1553798-3412-1.aspxThis is just a shot in the dark, but try Googling or Binging the following:[b]+"sql server" +iFilter +PDF +text filestream semantic[/b]Thu, 27 Mar 2014 11:20:07 GMTEric M RussellRE: Insert data from .pdf fileshttp://www.sqlservercentral.com/Forums/Topic1553798-3412-1.aspxIn Adobe:File&gt;Save As&gt;TextPDF table will convert like this:Arizona5Alabama4Kansas9Missouri3Montana2Read Text file, parse it out.Or, you might look at this application: Winautomation. Macro software that can read and write to sql db. it's an excellent application, I've used to to do some web scraping to store in SQL.Thu, 27 Mar 2014 06:47:31 GMTSQL2219RE: Insert data from .pdf fileshttp://www.sqlservercentral.com/Forums/Topic1553798-3412-1.aspx[quote][b]Confusing Queries (3/23/2014)[/b][hr][color="#36648B"]Hi everyone,We are facing a problem with [/color][url=http://www.rasteredge.com/how-to/vb-net-imaging/pdf-text-extract/][color="#36648B"]loading data text from .pdf files[/color][/url] [color="#36648B"]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 [/color][url=http://www.rasteredge.com/how-to/vb-net-imaging/pdf-reading/][color="#36648B"]read a pdf file[/color][/url][color="#36648B"]? Thanks & Regards[/color][/quote]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.aspxAs for "you want to insert data filed that is in tabular format into SQL table", maybe you can check this posthttp://social.msdn.microsoft.com/Forums/sqlserver/en-US/01bf1171-6165-4c29-9242-d7f11f9662d3/insert-pdf-fields-into-sql-table?forum=sqlintegrationservicesHope it offers some useful help.:-DTue, 25 Mar 2014 21:04:48 GMTcathyhill345RE: Insert data from .pdf fileshttp://www.sqlservercentral.com/Forums/Topic1553798-3412-1.aspxMay be with iText:http://itextpdf.com/RegardsTue, 25 Mar 2014 07:02:18 GMTVirgilio Licovali Bustos RamirezRE: Insert data from .pdf fileshttp://www.sqlservercentral.com/Forums/Topic1553798-3412-1.aspxSSC experts would definitely have an answer to this .. my wild guess though is :unsure: ....probably firstly converting it to excel and then reading that excel... or writing some code in some language eg. java .. or using some third party software to read text from PDF...Please see if following helps[url]http://stackoverflow.com/questions/4784825/how-to-read-pdf-files-using-java[/url][url]http://www.a-pdf.com/data-extractor/[/url]Mon, 24 Mar 2014 00:51:36 GMTSQLCJInsert data from .pdf fileshttp://www.sqlservercentral.com/Forums/Topic1553798-3412-1.aspxHi everyone,We are facing a problem with loading data from .pdf files 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? Thanks & RegardsSun, 23 Mar 2014 01:27:36 GMTConfusing Queries