After the initial training period, document data extraction systems offer a fast, reliable, and secure solution to automatically convert PDF documents into structured data. Especially when dealing with many documents of the same type (Invoices, Purchase Orders, Shipping Notes, ), using a PDF Parser is a viable solution.
Office Convert Pdf to Doc Text Rtf. Advanced features: provide the customized command line service for server and developer, convert PDF to DOC, TXT, RTF, drag and drop files, choose the entire folder to convert, intelligent processing of large files, easy to use, convert with one click, save the imported file list, create DOC, TXT, RTF with high good quality.

In your database store, create a table named 'docs' with these columns - docid, docname, docbinary. For this article, I have used a MS Access database. 'docid' should be an auto-incrementing field. 'docname' will be used to store PDF file names. 'docbinary' should be the blob field in which the PDF content is stored. A long time ago I manually convert Word documents that had all been in a hidden table directly into Access easily enough but unfortunately these documents were not made in a table format and many of the original Word documents are gone, all I have to work with are the pdf files.

Summary:

Our today’s topic of discussion is about how to convert Access report to pdf file. Besides that you will get idea on how to import/export Access report to pdf and much more…!

Many of you must have used MS Access to store several of your information but do you know you can add files to your Access database also? Well MS Access makes this tough task simple by defining a special attachment fields that hold complex data. If you are willing to use the PDF file in Access database then check out this post.

As it is specifically written with the main prospective to provide you all with every pinch of information regarding how to convert MS Access report to pdf file, Import PDF Files into Access Database and export Access report to multiple pdf files.

How To Import PDF Files Into Access Database

You can import pdf file in Access database simply by adding it from attachment field. Learn how it is to be done. Here we will perform this in two sections, so that you can understand it more clearly.

1: By Adding An Attachment Field

2: Add PDF To Table

Step 1: By Adding an Attachment Field

At first open your MS Access database and after then go to the Navigation pane.
Now make a right-click on the Access table within which you need to add your PDF document.
Tap to the “Design View” option. You will see that Access will display a table having name of the field on it. Scroll down to this table and go to a blank row having no field name on it.
Keep your mouse cursor on that particular row’s Field Name column. After then assign name for this attachment field. Suppose, you want to keep the field name PDF for easy identification then type PDF over there.
Just next to the name you have recently assigned you will see one drop-down menu of Data Type will appear to you. So, from this drop down menu choose the “Attachment” data type. After then press the “Ctrl+S” for saving up all the changes done by you.

Step 2 :Add PDF to Table

After make the table in database it’s time to insert PDF document into Access Database table.

From the menu bar of your Access database tap to the “View” tab. After then tap to the “Datasheet View.” Keeping your table in datasheet view, will help you in easy updating of the data in the table.
Now come to that row which is having the record that you want to update. Suppose, you need to add your PDF document into the 20th row, then you need to scroll to that row.
Go to the attachment field which you have added in the step 1. Now make double tap on that field for opening of the dialog Window of Attachments.
Hit on the Add option and this will open the Window of Choose File. From this Window you can choose your PDF attachment file.
After the selection of the PDF file you want to add in your Access table. Tap to “Open” button and then on “OK” option.

You will see that your PDF file is get added into the row of the table which you have selected.

How To convert Access Report To PDF

After learning how to open or import pdf file in Access database. It’s time to move into our next section i.e how toconvert Access report to PDF file.

Here is the step to convert Access report to pdf file. Follow it carefully:

Open your Access report.
After then go to your Access database menu bar Ribbon. Here tap to the External Data tab and then from the Export group choose the PDF or XPS option.

Choose the file or folder path where you want to save your Access pdf file.
After then tap to the Publish.

Tapping to the publish option will automatically open Access report in PDF file format.

All done…! Now you can see that your Access report is successfully converted to PDF file format.

Isn’t it easy…!

If you need to perform this task on regular basis then it becomes quiet irritating to perform this manual step. At that time you need some simple solution. With which in just one single click you can immediately export Access report to PDF file.

So, in our next step we will learn how to export Access report to PDF using VBA.

How To Export Access Report To PDF File Via VBA

In this section of my post you will learn about how to design a VBA function that help you to convert Access report to PDF file in just one single click of the button.

Now you need not to go every time on your Access menu bar to convert Access report to pdf.

Steps For Making A VBA Function Which Saves The Access Report In PDF File Format

1. Add One Command Button Within Your Report

Try the following method if you are already having an Access report. If it’s not then make it first.

Open your Access database design view and then add one button on Report header section. Just as shown in figure.

Assign the name of this button as cmd_exportPDF. For this perform the following steps:

In the design view, choose the button.
Press the ALT + Enter button from your keyboard to open the Property Sheet.
Now tap to the Other tab and then on the Name
After then you need have changed your Name value to this; cmd_exportPDF.

2. Add code for the command button

For adding up the code, you firstly need to add one On_Click event on the button.

Keeping the above cmd button selected, once again go to the Property Sheet.
Tap on the Event
Search for On Click and then select…
You will see a Choose Builder menu gets pops up on your screen. Select Code Builder and tap to the OK
After this VBA Editor gets open on your screen.

You have to just copy the below code.

Convert Pdf To Access Database

Remember: you have to update the values for file name & folder Path. You can see in the comment section, each one have an asterisk (*).

Function FileExist(FileFullPath As String) As Boolean
Dim value As Boolean
value = False
If Dir(FileFullPath) <> “” Then
value = True
End If
FileExist = value
End Function

Private Sub cmd_exportPDF_Click()

Dim fileName As String, fldrPath As String, filePath As String
Dim answer As Integer

fileName = “Member Contact Details” ‘filename for PDF file*
fldrPath = “C:UsersJessicaDesktopPDF Exports” ‘folder path where pdf file will be saved *