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.

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.

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?

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

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).

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?

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.

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.

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