Import Data from word into Access Database

[AReilly]

Hi There,
I am just wondering if anybody has any guidance on how to go about importing the data from a word document into Access Tables (VB6 front end). Is there any good links on this anywhere or would it be better to look at excel or text files only or something else?

Any advice would be appreciated,


Thanks

[Hack]

Would you be doing the import into a single memo field in Access?

[RobDog888]

Are you just wanting to save the text, the formatting too, or the entire file itself?

[AReilly]

Hi there,
Thank you for the reply. It is to import the data only (and maybe the document path) into all the fields of a record in a table. Actually, the information would need to be fed into multiple tables (all the fields in the records of each table), does that make sense?

Any advice would be greatlu appreciated,

Thanks

[Hack]

I word document is nothing but one big, formatted text file.

So, if the information you want is in paragraph form, then that paragraph would have to be parsed out into individual blocks of text that could be inserted into individual table fields.

I'm not sure how you would do that, so I would need to see an example of the contents of a typical word file that needs to be broken up into pieces that can be saved into Db fields.

Can you post one?

[RobDog888]

How would you determine what content goes into which fields/tables? Are you using bookmarks or ?

[AReilly]

Hi there,
I've attached the headings of the type of information that needs to be imported below. It is only a few headings at the moment, I'm thinking of just keeping it as an Excel file, its just that I thought it might be limiting. Do you happen to know any good code links for importing from Excel?

Thank you for your help