Highlighted

ms access pdf file

New Here ,
Sep 27, 2020

Copy link to clipboard

Copied

Hi,

My small business receives a lot of PDF Invoices from which I would like to pull the data into an already existing Access Database (stuff like e.g.Invoice Number, Date of Invoice, Supplier, Cost net. and Cost total). The Database has to detect the Data from the PDF and put it into the Database into the right Position (eg. Scan the PDF invoice for the invoice number and put it into the Database in the invoice number column. And of course, for each invoice, there has to be a new Dataset. The more data I can extract the better it would be. Is it possible to train Access or the PDF-reader to know which data is which?

TOPICS
Create PDFs, Edit and convert PDFs, PDF forms

Views

64

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

ms access pdf file

New Here ,
Sep 27, 2020

Copy link to clipboard

Copied

Hi,

My small business receives a lot of PDF Invoices from which I would like to pull the data into an already existing Access Database (stuff like e.g.Invoice Number, Date of Invoice, Supplier, Cost net. and Cost total). The Database has to detect the Data from the PDF and put it into the Database into the right Position (eg. Scan the PDF invoice for the invoice number and put it into the Database in the invoice number column. And of course, for each invoice, there has to be a new Dataset. The more data I can extract the better it would be. Is it possible to train Access or the PDF-reader to know which data is which?

TOPICS
Create PDFs, Edit and convert PDFs, PDF forms

Views

65

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Sep 27, 2020 0
Most Valuable Participant ,
Sep 27, 2020

Copy link to clipboard

Copied

It's not possible to extract data from a PDF file directly into a DB. It is possible to create a text file with the data, which can then be imported into Access, though. However, extracting the data from files with different structures is going to be very difficult. Unless all (or at least some) of the invoices have the same structure you won't be able to do it, and either way it will require the development of a complex, custom-made script.

 

If you can share some sample files I'll be happy to examine them and let you know if I think it's doable, and if so how much I will charge to create this tool for you.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 27, 2020 0
New Here ,
Sep 27, 2020

Copy link to clipboard

Copied

thanks for your help i have found a solution

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 27, 2020 0
jane-e LATEST
Adobe Community Professional ,
Sep 27, 2020

Copy link to clipboard

Copied

If the PDF is a form with form fields, this is straightforward:

 

  • Open any PDF (to be able to access tools) > Prepare Form tool

 

  • Merge Data Files into Spreadsheet > Add Files

 

  • Select files > then select the files

 

  • Click Export to export to .csv. The default is report.csv

 

  • In Access, create an Append query to appent the data from the .csv file to your existing Access table

 

Can you get them to use a PDF form that you create and send them?

 

~ Jane

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 27, 2020 0