MS Access: Importing multiple .doc's for cataloging?

All hardware or software issues that do not have a specific forum go here.

Moderator: The Mod Squad

Post Reply
gamepyrate
Black Belt 1st Degree
Black Belt 1st Degree
Posts: 1359
Joined: Mon Aug 19, 2002 12:00 am

MS Access: Importing multiple .doc's for cataloging?

Post by gamepyrate »

Hello all.
Long time no see.
Problem: I am trying to create a means of compiling the information from multiple .doc files (which are completely identical except for a few user-inputted fields like "date" and "quantity", etc.), and have that data easily searchable.
My idea: I was thinking that MS Access is the way to go to build a database. I do not want to have to manually import the values for each and every form, but instead want it automated (since the forms are 99% identical).
My question: Is there a way of doing this?

Further information: The form in question can actually be located here: https://www.keysupport.net/fileserve.ht ... ntKindID=3 . It is used to order cryptographic equipment for COMSEC (GOV/military job). I've been trying to read beginner's manuals on SQL and Access, thinking they do the trick, but I have not yet been able to find how automated importing of multiple .doc's could be accomplished. Or maybe it is not possible? I saw 3rd party software that sounded like it did the trick, but getting the authorization to run a 3rd party software on a government computer is a pain in the rear.

Thanks for help, if any.
Cheers
Peter
User avatar
Karlsweldt
Mobo-fu Master
Mobo-fu Master
Posts: 20868
Joined: Wed Nov 12, 2003 11:57 am
Location: 07438

Post by Karlsweldt »

The term is "mask sorting for documents".
It is a feature by another name in MS Office and other programming.
Example:
Another example:
Basically, you create a subnet mask that excludes all identical data of all documents.. then sorts the desired criteria by type or category, and then displays that criteria by either age, alpha or how you wish it displayed.

Look in the program for "sort by:".
[email protected] to solve mankind's maladies.. in our lifetimes!
Post Reply