Anyone Know a program that can do this?

Discussion in 'OT Technology' started by 1ns4n1ty, Jul 28, 2006.

  1. 1ns4n1ty

    1ns4n1ty That was mean, Mortari

    Joined:
    Jun 28, 2006
    Messages:
    4,677
    Likes Received:
    0
    i have a large amount of paragraphs that we need to copy and paste a large amount of questions and answers into microsoft acsess, to database them. is there any way i can avoid having to do this manually, there are 700 questions and 700 answers in separate .txt files. :x:
    HELP ME OT!!!
     
  2. MSIGuy

    MSIGuy om nom nom nom!

    Joined:
    May 30, 2005
    Messages:
    4,724
    Likes Received:
    0
    Do you have to paste them into Access? If you really wanted to you could write a bash script (or C, or whatever) to do that I'm sure.
     
  3. 7960

    7960 New Member

    Joined:
    Oct 17, 2004
    Messages:
    60,415
    Likes Received:
    0
    Location:
    New England
    I don't know Access that well but I know Excel has an import wizard and you can have a user definited delimiter. I can't believe they'd put that in Excel and not Access, but if they did maybe you can import the questions into Excel then either have Access get them from there or export them in a format Access understands.

    This is better asked in programming. Good luck.
     
  4. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    why not just write a sql query and have it spit it out into a text area. copy and paste that?
     

Share This Page