how do I import part of a word doc in access?

L

lula

I have 2 things: a word document where people fill out in some specific
places with some computer repair requests and then I have a form in Access
2000 that I need to capture or to grab that information so I don't have to
enter it one by one.

Can I do that??

also the word document has "gray spaces" where the people is able to write
or to choose from a list of things.
ex: urgency: .................. (that is a gray space) and when they click
there, it shows a list: High, low, Average. they select one and that is what
I need to capture in my database.

I have like 10 different items....

can anybody help me??? I appreciate all your help. thx
 
L

lula

I'm new in programming with access so if anyone can help me that would be
great!!!

thanks
 
J

Jose Aleman

Hi Lula,

I don't think you can transfer the information from word but you can do it
from excel.

1. You can copy and paste your information from word to excel to create the
spreadsheet.

2. Once you have your spreadsheet, go to File > Get External Data > and
click import. Look for your spreadsheet and follow the instructions.

For a drop down menu, you can create a new table name Urgency and use the
lookup wizard to connect it with your main table where you will have your
information.
 
B

Bob Miller

You should be able to save just the data when you get the forms back by
checking the Save data only for forms on the Save tab of Tools,
Options.
Then on the File menu, click Save Copy As.
Type a file name in the File name box.
In the Save as type box, select Plain Text, and then click Save.
Select a text encoding option, and then click OK.
Word saves the form field data in a comma-delimited text file that can
be imported into Access.
Do this for each form returned.
You can create a new table for the first form data imported and each
susequent import can be placed in the existing table created for the
first.
 
L

lula

thank you jose ...
I was looking through the access help as well, and I now notice that I can
import the word doc to my database but it needs to be delimitated by commas
or tabs.... What I don't want to do is to actually modify that document. I
want my database to convert it and transfer the information so I don't have
to do it myself for each record. the same thing with the excel doc... I
don't want to copy-paste every piece of info from each word doc to excel to
then be able to import it....

do you know if I can do a macro o something that can help me with that???
or is there anything else I can do???

thank you!
ohhhh and I forgot to mention before that I already have the tables that
contains those drop down menues codified. I have an Urgency table with the id
and the description, a Category with the id and the description, etx...

if you figure something else that could help me it would be great!!! thanx
again.
 
L

lula

thank you bob... that worked great! I can import my data that way...

just in case (so I don't have to do it for each doc).... is there any way
that I can create a macro or a rutine that when I click on a button does
that? I mean, if I have the word document on a specific path, may be there's
a way that I can just click on a button and imports the data for me, instead
of me doing all that process....

the only thing that I may have to do is just click on the "save data only"
and save the doc as a text only or plain text.

It would be really helpfull if you can answer me back. I have so many
computer repair requests that if I can do that, it's going to take much less
time and I'm not going to spend all my day long importing these things...

ok, thank you soooo much for your help!!!
 
L

lula

lula said:
thank you bob... that worked great! I can import my data that way...

just in case (so I don't have to do it for each doc).... is there any way
that I can create a macro or a rutine that when I click on a button does
that? I mean, if I have the word document on a specific path, may be there's
a way that I can just click on a button and imports the data for me, instead
of me doing all that process....

the only thing that I may have to do is just click on the "save data only"
and save the doc as a text only or plain text.

It would be really helpfull if you can answer me back. I have so many
computer repair requests that if I can do that, it's going to take much less
time and I'm not going to spend all my day long importing these things...

ok, thank you soooo much for your help!!!
Click to expand...
 
Top