Import data from a PDF file to a table in Access 2013 without Adobe Acrobat

[DonCammne]

Hi! I'm new in this forum and I hope that I'll be understandable.


My problem is, like I said in the title, importing data from a PDF file. I found this in internet:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=977
N.B. in the bat file, I changed the line

pdftotext.exe -layout YourPage.pdf

with

pdftotext.exe -table YourPage.pdf

because I think that is easier to import the data, but I'm not sure of this...

but it's for Excell and I don't understand how to use it in Access. Furthermore I don't know how to import the data from the txt file in a table.
Someone can halp me? I found in internet quite nothing.

[ItsMe]

In order for that code to work you will need to download the PDF utility from FooLabs and also the BAT file. Additionally, some of the code will not work in Access. For instance, I am not aware of a Wait Method within Access. I have always created my own custom Wait function.

Beyond that, I have used third party software/add-ins to interact with PDF files. You may have an issue with a 10 to 15 year old PDF utility from FooLabs. I did not try the FooLabs link. If they have an updated utility, you may need to update the separate BAT file, too. The best way would probably be to use a full version of Acrobat and automate the PDF directly from Access. However, this requires Intermediate to advanced VBA programming.

[Perceptus]

There are several wizards for handling the importing of data into a table that are within Access. Check the External Data Tab in Access, Or look under the Office Button for import options(not sure where the option is in access 2013).

It may be easier to use that tool you found, to import that data into Excel. And then Use Access to create a Linked Table that points to that Excel File as a resource.

Importing data from a pdf to text is always a lil sketchy. A PDF is more of a picture, than a document with text.

[DonCammne]

Thank you for the help, but the main problem is hoe can I open the PDF file in access, because the line

PageName = Application.GetOpenFilename("YourPage, *.pdf", , "YourPage") 

doesn't work in Access. I tried with

.FileDialog

but nothing.

[DonCammne]

Thank you for the response! I try it right now, but first, to be sure that I understood: I have to import the data from the PDF file to an Excell file, then import the data from the Excell data to Access, right?