How to import word and PDF files into Access

[asaini]

Hi,

I am new to this forum and also novice in Access.

Following is my query:

I have two documents one in word and another in PDF format.

I want to import word document into an access as a Form. This word document has fields: Name, address, date of birth etc.

When I enter the data in this form I want it to be saved to access database (so that data can be accessed as and when required)

Next step..

I want to add .PDF into access as form as well. This also has fields such as Name, Address, date of birth etc (same as above). I want these fields to be automatically populated with data from first form.

Please suggest how should I go about this. As I said above I am a novice in Access

Your help will be much appreciated.

Adarsh

 

[The_Doc_Man]

There are ways to do this but you have a lot of reading ahead of you.

What you want to do is study up on "Application Objects" (which is a starting point for browsing the Access and VBA help files in the area you will need to study). Also open up Word and find its help topics on VBA including the data structures it presents to programs that work with application objects. Word's help will tell you more about what you want to know and will give you some decent examples.

In Word, what you want isn't that hard with a little bit of intelligent design. Never tried doing it with PDF but if you have the appropriate kind of PDF creator utility and the .DLL that lets Access do a PDF Application Object, it should be possible.

I never did exactly this, but I came close. I made my Word document a table-oriented form where the question was on the left side of a two-column table and those fields were write-protected. The right side was blank and you could edit in the text you needed for your answer. Then I would run this form that included the "Common Dialog: Open File" tool. (Search this forum for the topic...).

Inside Word, tables are especially easy to work with. You need to read up on "collections" because data retrieval will surely require some collection traversal.

 

[asaini]

Thanks The Doc Man,

I was in impression it might be bit easier.

I am Systems Admin by profession and don’t know much about programming.

I thought it must be a case of importing documents as access forms and then somehow link the blank columns in the forms and when I fill information in first form e.g name, address, DOB etc, that information could somehow get populated on the second form when i open it to fill the information (this is to save time duplicating efforts of filling same information again in second form).