Access Tool (1 Viewer)

[erai1239]

I need to extract data field from a Word document into Access Database. Any suggestions on Access tools or VB Codes!

 

[Ron_dK]

As far as I know, you can't import Word data into Access.
What you could do is, save your word document to an *.txt file and use the Access wizard to import the data.
Or copy the word data to an Excel sheet and import from an *.xls file.

Hth

 

[erai1239]

Thank for your reply! However, I need to be able to do this as an macro. Any suggestions on codes or a tool used for this type of import.

erai1239

 

[Ron_dK]

As said before, use the access import wizard to set up a data import. This can't be done with Word, since Access can only import txt or csv , tab or asc.
You might do a search on Import data on this forum.

Hth