Help: Importing data from Word Form Fields to Access

[FastHeather]

Hi All,

Is it possible to transfer data from MS Word form fields to Access?

I have a few hundred documents that are all built off the same template, using form fields, and I need to transfer data from some of these form fields to Access tables. Can it be done or do I need to spend a month doing cut and paste?

Thanks all.

Heather

 

[AppStaff]

yes it can be done using ole, automation or dao/ado.

 

[FastHeather]

That's great!

What's the best way to transfer the data from Word field forms to Access tables?

Thanks!

Heather

 

[AppStaff]

Sorry for the late response. Actually re-reading your issue your easiest solution would probably be to try to convert your data into an importable file into access. If you can get your data into a csv format or a table and then use the convert table to text feature in word then getting it into access should be easy. I don't have time to do the leg work for you and without specifics about your data its hard for me to narrow the focus but if you research into importing files in access and the other tools i mentioned I'm sure you can find a solution that is best for you.