UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Retrieve Data From Pdfs, Any Version    
 
   
GroverParkGeorge
post Nov 20 2019, 10:18 AM
Post#1


UA Admin
Posts: 36,171
Joined: 20-June 02
From: Newcastle, WA


I've been asked by a colleague about importing data from PDFs into an Access/SQL Server application.

First, being retired, this is a project that I will probably pass on.

That said, I was hoping to be able to offer some advice on how to proceed. In a nutshell, the client will receive multiple reports in pdf format, I'm guessing dozens of them at a time. The data from those pdfs needs to be imported into the SQL Server tables. In the past, this was done with text or csv files, as I recall. For whatever reason, they now want to use PDFs instead.

So, my question is whether there are 3rd party tools that can identify and extract the relevant data from a PDF into a temp table in Access for export back to the SQL Server. Or is there a way to import the data directly into the SQL Server.


--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
cheekybuddha
post Nov 20 2019, 12:28 PM
Post#2


UtterAccess Moderator
Posts: 11,870
Joined: 6-December 03
From: Telegraph Hill


A few suggestions here on SO

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
theDBguy
post Nov 20 2019, 12:29 PM
Post#3


UA Moderator
Posts: 76,819
Joined: 19-June 07
From: SunnySandyEggo


Hi George. Not sure about 3rd party tools (there must be some out there), but my demo on working with PDFs (on my website) uses Acrobat API to extract data from a PDF form. You could take a look.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Nov 20 2019, 12:31 PM
Post#4


UA Admin
Posts: 36,171
Joined: 20-June 02
From: Newcastle, WA


Thanks. I should have been more precise. This needs to be done from Access, preferably, but it sounds like there are tools that can be adapted to do the job.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
GroverParkGeorge
post Nov 20 2019, 12:32 PM
Post#5


UA Admin
Posts: 36,171
Joined: 20-June 02
From: Newcastle, WA


I should have started on your website. thumbup.gif

Unfortunately, I don't think they're working with Acrobat forms, though. More like "reports" saved as PDFs.
This post has been edited by GroverParkGeorge: Nov 20 2019, 12:33 PM

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
cheekybuddha
post Nov 20 2019, 12:34 PM
Post#6


UtterAccess Moderator
Posts: 11,870
Joined: 6-December 03
From: Telegraph Hill


>> This needs to be done from Access <<
Ah, I see! You meant third party Access tools!

I just envisaged shelling out to on of the suggested tools in the SO thread.

--------------------


Regards,

David Marten
Go to the top of the page
 
theDBguy
post Nov 20 2019, 12:35 PM
Post#7


UA Moderator
Posts: 76,819
Joined: 19-June 07
From: SunnySandyEggo


Ah, well, PDFtk can extract text from a PDF, but then determining which one is data would be another matter.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Nov 20 2019, 01:08 PM
Post#8


UA Admin
Posts: 36,171
Joined: 20-June 02
From: Newcastle, WA


Yes, sloppy posting on my part.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    6th December 2019 - 10:34 PM