Import Word data to Access database

[Trevor Mills]

I need to import the data from some 1,500 resumes in to a database so that I can search for key words eg skills, qualifications etc.

I can identify Word tables and thus columns, rows, cells and import these in to appropriate columns in an Access table. I can also identify paragraphs to import in to a memo field.

I am struggling to identify the order in which these tables and paragraphs appear in the document as the documents are all different. Paragraphs are randomly interposed between tables.

Thanks in advance for any pointers or suggestions.

Trevor

 

[Doug Robbins - Word MVP]

Believe it or not, you are actually a lot smarter than a computer. So if
you are having trouble making the indentification, a computer will have no
chance.

Seriously though, you would have to provide some more information on the way
in which the resumes differ and how you (as a human being) can identify the
parts of interest. Unfortunately, if it's merely by the content then it
makes it nigh impossible to automate the process.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

I need to import the data from some 1,500 resumes in to a database so that

I can search for key words eg skills, qualifications etc.

I can identify Word tables and thus columns, rows, cells and import these

in to appropriate columns in an Access table. I can also identify paragraphs
to import in to a memo field.

I am struggling to identify the order in which these tables and paragraphs

appear in the document as the documents are all different. Paragraphs are
randomly interposed between tables.

 

[Trevor Mills]

Doug Thank you for your response.

I guess I didn't explain my problem very well. I have already developed a whole lot of queries in Access that analyse the data in a resume and provide me with more structured data than the raw Word document. I have built sample data in the database by opening the Word document and using copy and paste to transfer the data in to an Access table.

I am battling to automate the importing of data
eg a word document may be "constructed" as follows

table(2)
paragraph(1)
paragraph(2)
table(3)
table(1)

How do I programmatically identify that para(1) follows table(2) and precedes para(2)

Hope that this is clearer.

thanks

Trevor

 

[Doug Robbins - Word MVP]

It's not really much clearer. How do you identify Paragraph(1) and
Paragraph(2), let alone their relative position.

Once you can identify the objects themselves, you can determine their order
by getting the Range.End of each object. The problem is identifying the
objects.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

Doug Thank you for your response.

I guess I didn't explain my problem very well. I have already developed a

whole lot of queries in Access that analyse the data in a resume and provide
me with more structured data than the raw Word document. I have built sample
data in the database by opening the Word document and using copy and paste
to transfer the data in to an Access table.