Search text and import into Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ThePolymathicMonk - 28 Jul 2005 16:07 GMT

I am (attempting) building an employee db in Access. The lofty goal is to do
keyword searches of present and potential employee resumes and populate table
fields based on the search results. Is this even possible?

Reply to this Message

Ken Snell [MVP] - 28 Jul 2005 16:28 GMT

Possible? Yes. You'd read in the entire resume (text file) as a memo field
into a table, and then search the memo field for your desired words, and
then update other tables based on your findings.

Signature

Ken Snell
<MS ACCESS MVP>

>I am (attempting) building an employee db in Access. The lofty goal is to
>do
> keyword searches of present and potential employee resumes and populate
> table
> fields based on the search results. Is this even possible?

Reply to this Message

ThePolymathicMonk - 28 Jul 2005 17:31 GMT

Thanks Ken,

I will give that method a try...I am sure this will take several layers of
queries...to get the data I want.

Thanks Again,

KMN

> Possible? Yes. You'd read in the entire resume (text file) as a memo field
> into a table, and then search the memo field for your desired words, and
[quoted text clipped - 5 lines]
> > table
> > fields based on the search results. Is this even possible?

Reply to this Message