Transferring Word docs to Access?

[JayE]

Hi everyone,

I have an Access databases, from which I run a number of macros to print the company's "hygiene schedules" each week.

The macro runs a series of Access reports. However, I wish to incorporate - without too much work/time - a few documents which are currently Word documents (2000).

3 of the Word documents are used as front pages for the schedules and 1 is used as a back page for the schedule. At the moment, I have to manually collate the Word document front pages with the schedules and the back page.

Is is possible to transfer the content of the documents from Word format into an Access report, either automatically or using Copy and Paste. Most of it emcompases Word tables which would come across "as is", but I have an idea that some of the info could be automatically filled in by Access from the fields in the tables.

Bringing the documents into Access format would enable me to include the front/back pages in the macros and mean I would no longer have to collate the schedules, and perhaps - even better - I would no longer have to fill in some details by pen.

Can you advise where I start on this project? I am sure you would need more info, which I'd be happy to provide.

Kind Regards,
Jay/UK

 

[pdldavis]

Hi, For regular documents, you can use the insert tab, select object and click on Create From File. Browse and select the document you are interested in.