Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by lula, Nov 3, 2005.

  1. lula

    lula
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    Importance Of Dastar History of Sikhism Aug 12, 2016
    Importance Of Tirath / Pilgrimage As Per Gurbani Gurmat Vichaar Jun 1, 2016
    Superheroes: Arjan Bhullar Explains Wrestling's Importance In The Sikh Community Sports & Fitness Apr 15, 2016
    Important decisions in life Questions and Answers May 25, 2015
    Friendship Between Genders... Important Question Questions and Answers Dec 20, 2012

  3. lula

    lula
    Expand Collapse
    Guest

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

    thanks

    "lula" wrote:

    > 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
     
  4. Jose Aleman

    Jose Aleman
    Expand Collapse
    Guest

    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.


    "lula" wrote:

    > I'm new in programming with access so if anyone can help me that would be
    > great!!!
    >
    > thanks
    >
    > "lula" wrote:
    >
    > > 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
     
  5. lula

    lula
    Expand Collapse
    Guest

    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.

    "Jose Aleman" wrote:

    > 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.
    >
    >
    > "lula" wrote:
    >
    > > I'm new in programming with access so if anyone can help me that would be
    > > great!!!
    > >
    > > thanks
    > >
    > > "lula" wrote:
    > >
    > > > 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
     
  6. Bob Miller

    Bob Miller
    Expand Collapse
    Guest

    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.

    lula Wrote:
    > 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



    --
    Bob Miller
     
  7. lula

    lula
    Expand Collapse
    Guest

    Re: how do I import part of a word doc in access? HELP! :-(

    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!!!



    "Bob Miller" wrote:

    >
    > 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.
    >
    > lula Wrote:
    > > 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

    >
    >
    > --
    > Bob Miller
    >
     
  8. lula

    lula
    Expand Collapse
    Guest

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

    "lula" wrote:

    > 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!!!
    >
    >
    >
    > "Bob Miller" wrote:
    >
    > >
    > > 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.
    > >
    > > lula Wrote:
    > > > 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

    > >
    > >
    > > --
    > > Bob Miller
    > >
     

Share This Page