Go to the attachment field which you have added in the step 1.Suppose, you need to add your PDF document into the 20th row, then you need to scroll to that row. Now come to that row which is having the record that you want to update.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. From the menu bar of your Access database tap to the “View” tab.

After then press the “Ctrl+S” for saving up all the changes done by you.Īfter make the table in database it’s time to insert PDF document into Access Database table.

So, from this drop down menu choose the “Attachment” data type. Just next to the name you have recently assigned you will see one drop-down menu of Data Type will appear to you.Suppose, you want to keep the field name PDF for easy identification then type PDF over there. After then assign name for this attachment field. Keep your mouse cursor on that particular row’s Field Name column.Scroll down to this table and go to a blank row having no field name on it. You will see that Access will display a table having name of the field on it.

Now make a right-click on the Access table within which you need to add your PDF document.

At first open your MS Access database and after then go to the Navigation pane.

Here we will perform this in two sections, so that you can understand it more clearly.Ģ: Add PDF To Table Step 1: By Adding an Attachment Field You can import pdf file in Access database simply by adding it from attachment field. How To Import PDF Files Into Access Database If you are willing to use the PDF file in Access database then check out this post.Īs 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. 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.

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

Convert pdf to access database