Import data from Word into Access DB?

[things]

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.

p.s, is there any commerical software developed to accomplish this task? certainly, some cheap ones.

 

[dyarwood]

Can you in anyway use a delimited text structure. This can then be imported into a table?

dyarwood

 

[it2hill]

Good Day,

If this is only one document that will be filled out multiple timed, you can define bookmarks and using VBA pull that information into Access. If this is what you are looking for, let me know. If you are wanting to use existing word documents that have already been filled out... then it gets a little complicated. All said and done, you have to somehow define the source of the text that you will pull from. Tables and bookmarks are the easiest way to define the source.

IT2

 

[things]

Hi dyarwood
I am quite sure about what you mean "a delimited text structure".

Hi it2hill
I have got to process more than 3000 existing CV documents in my computer. And that's why I am looking for some automatic solution or at least semi-automaic solution. I found a paper from Microsoft that VBA can hlep to import data in a form/talbe of a word doc into access db. But how are those CVs?

 

[things]

May I give more detail on my problem?

for example, I have some CVs in this kind of strucutre:
-----------------------------------------
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?

 

[things]

have anyone met the similar problem before?