Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2003
    Posts
    4

    Unanswered: import data from Word into Access

    Hi dear

    I am looking for a solution to transfer information from a CV Word(XP) document into an Access (XP) database.

    I have tried some ways after I searched the Internet. But mainly they only deal with table/forms in the document.

    So how is the semi-structured documents like a CV?

    Please help me. This is urgent as required by my employer.

    You can email me or reply here. I would really appreciate any suggestion from you.

    Thanks in advance.

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    I don't know what a CV Word document is but if you
    are referring to .csv files then all you have to do in
    Access is choose menu item

    File --> Get External Data --> Import...

    and select the .csv file you want to import into Access.

  3. #3
    Join Date
    Dec 2003
    Posts
    4

    The CV I mean here is a personal resume

    Thanks, upstairs.

    The CV word doc here means a personal resume. See we have this kind of free or unstructured data format in this kind of docs.

    -----------------------------------------
    Name: XXXXXXX
    Sex: XX
    DOB: XXXXXX
    Tel: XXXXXXXXXXX
    Email: XXXXXXXXXXXXX
    JobTitle: XXXXXXXXXXX XXXXXX
    Experience: XXXXXXX;XXXXXX;XXX
    -----------------------------------------
    is there any way I can programe something that automatic recognize those piece of data in each doc and extract them into some midware or directly into Access db?

    I know some software do provide this kind of facilities in their package. But is there anyone cheap and home-made?

  4. #4
    Join Date
    Nov 2003
    Posts
    91

    Re: The CV I mean here is a personal resume

    Well, if your records are pretty much the same as you
    have described, then all you have to do is run a sed
    script to convert these into a tab-delimited record,
    which the following script does.
    To run this script, from the command line (DOS prompt) type

    sed -f sedscript 'name_of_CV_file' > 'tab_delimited_file'

    (assuming you call the following sed script 'sedscript.')

    If you don't have sed installed on your machine you can
    get it at http://gnuwin32.sourceforge.net/packages/sed.htm
    This version of sed requires libintl-2.dll and libiconv-2.dll
    that is also provided on the same HTML page.

    After you create a tab-delimited text file, you suck it into
    Access pretty much as I already described above.
    In the following sed script the lines that start with '#'
    are comments (which may remain in the script).

    The following sed script should go into a text file and named
    something like 'sedscript':

    ### Delete all the ----------- lines
    s/----*$//
    /Name: / {
    ### Read next 6 lines in as a block
    N
    N
    N
    N
    N
    N
    ### Delete 'Name:'
    s/Name: *//
    ### Delete 'Sex:'
    s/Sex: *//
    ### Delete 'DOB:'
    s/DOB: *//
    ### Delete 'Tel:'
    s/Tel: *//
    ### Delete 'Email:'
    s/Email: *//
    ### Delete 'JobTitle:'
    s/JobTitle: *//
    ### Delete 'Experience:'
    s/Experience: *//
    ### Change newline to tab character
    s/\n/\t/g
    }
    ### Delete empty lines
    /^$/d

  5. #5
    Join Date
    Nov 2003
    Posts
    91

    Re: The CV I mean here is a personal resume

    Oh, and the CV Word .doc file has to be converted to a
    text file, but that's easy to do because Word can save
    files as plain text:

    File --> Save As...
    select 'Plain Text' and enter a file name
    hit 'Save'
    and finally hit 'OK' to get out of the 'File Conversion'
    dialog (Windows(Default) line format is OK).

  6. #6
    Join Date
    Dec 2003
    Posts
    7

    what is the purpose of this

    I have a better ideas for this, may be yo can create a table in WD document where you can add the data, then use some macro or VBA script to import them, i have an example on how to do it, but you have to be good at programming VBA?

    what knocks my head is>>> why do yo want to do this?

  7. #7
    Join Date
    Dec 2003
    Posts
    4

    Re: The CV I mean here is a personal resume

    [SIZE=1]Originally posted by vanekl
    Thanks a lot, vanekl. I will try it. But it looks not automatic. I mean I am going to transfer information from over 4000 CVs to the Access DB.

    [SIZE=1]what is the purpose of this
    As I said, I am going to deal with thousands of CV Word Documents. I am sorry I don't understand quite well here about "create a table in WD document where you can add the data, then use some macro or VBA script to import them". The problem I have is all information is just listed in the Word document and unstructured and not in a form or table. Can you give me some advice on this?

    Thanks indeed.

  8. #8
    Join Date
    Dec 2003
    Posts
    7

    yes i can

    please send me some cv file (fake one is OK) and i'll try to make a rutin to import them in a MSaccess db via a macro
    if i do it i will post it
    mwjawish@hotpop.com

    see you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •