PDF into the database

[UT227]

I need to put a pdf into my database. It cannot be linked. It needs to be inside the database itself. What I'm trying to do is to have a button in a form that will look for the file and upload it into the database placing it into a table.

[June7]

You want to embed objects into Attachment type field or OLEObject type field. I've never used OLEObject.

Options:

1. use the Attachment field Manage Attachments dialog

2. use FileSystemObject to allow users to navigate to and select file. Then embedding file requires special recordset handling.
Select a File or Folder using the FileDialog Object - Microsoft Access / VBA (bytes.com)
Working with Attachment Fields - MS-Access Tutorial (sourcedaddy.com)

[alansidman]

Are you tryin to embed as June has indicated or do you with to have the data in a table that can be queried?

[June7]

Good question. If you want to extract data from an OCR or form-fill PDF, that is completely different.

[UT227]

I have an OLE field in a table. I just want to embed it there.

[UT227]

I had to use the Access method instead of using the File Dialog. I couldn't get it to work and I'm on a deadline. I'll keep trying after I show how it should work. I have another question. I have uploaded the OLE file. I would like to have a button to print the PDF. Right now, I have to double click the OLE field. I don't want to show that field to the user. I want a button to open it up. The table is [tblDocuments]. The OLE field is [Document].

[June7]

Review

Extracting files and data from OLE Object fields - Yohz Software Development Blog

OLEtoDisk (lebans.com)

[alansidman]

I am confused by your response. If you are looking for data in a PDF to populate an Access Table then...

Import your PDF to Power Query and then Close and Load your data to Native Excel. You can then bring your data into Access either by importing or linking.

https://www.youtube.com/watch?v=C6vqy30PDnE