Upload Word document into Access

[Hogmoss]

I am trying to upload a Word document into Access and having difficulties,
here is what I am trying to do.

Begin with a Word procedural document, used for documenting test
steps/results, scan into Access. Currently paper forms are being used and we
are trying to go all digital. We want to scan the current template into
Access and link the test procedures in the Word document to tables within
Access. Within Access we have created a "dummy" interactive version of this
digital test procedure, but we cannot parse the Word document into Access and
have the relationships stay connected and the data entered into the proper
tables. I have searched and searched and have not been able to find any help,
any info would be greatly appreciated. Thank you.

 

[GBA]

well you should probably be in the import/export area for this question;

you need to save it as .txt - and then define delimiting or fixed width
during the import process....

 

[Hogmoss]

I'll give that a try, thank you. What about automation? Another user from a
different forum suggested that option. They said they were able to make it
work by creating an instance of Word to access the document from Access.

 

[GBA]

doesn't sound like anything I've ever seen. I am assuming you have data, it
is in/on a Word doc, and you want to import that data into an Access table
(rather than re-keystroke it).

 

[Hogmoss]

We have a test procedure template in Word format that testers use to perform
steps and record their answers/comments from each step. For archiving reasons
it needs to be accessed through Access and the original needs to stay in Word
format. We are trying to create an Access db that the users can access the
test procedure they need, input their answers into the Word document and then
upload the results back into Access. It would be much easier to covert the
Word documents I know but that is not an option for us.

 

[GBA]

well you are going against the tide with this approach. Word and Access
just don't integrate in this manner. Once again, you can manually convert
that Word doc to txt and then maybe with some editing get it to be
import-able into Access.

Microsoft's product - Infopath - is intended to be a forms consolidation
product that you probably should look at.

But today anything distributed like this would be purely web based from
beginning to end.

If the field user has the ability to have a local copy of Access - it would
be better to forward a copy of that - rather than a copy of a Word doc - in
terms of importing into a common database...

 

[Hogmoss]

Yes I know, it's not us it's the product owner who has to have it this way.
We have explained how Word and Access don't integrate easily but they still
want it this way.

I have recently started looking into the InfoPath route, I'm somewhat
familiar with it but not integrating it with Access. I appreciate all of the
input.

Thanks,