Importing Text from Word

[Joe]

This is a tricky one. I have an exam database built in Access that stores
many questions and generates exams. Up until now, I have been copying and
pasting the questions from a Word file and entering it into the appropriate
fields in my exam question table.

As this is becoming excessively tedious, I was wondering if anyone could
suggest an alternative method for moving text from a Word file into different
fields in an access table.

Any help will be greatly appreciated.

Thanks,

Joe

 

[John Nurick]

Hi Joe,

It all depends on how the Word document is structured. If it has a
perfectly regular structure in which each element of data can
unambiguously be recognised as such (e.g. cells in a table, paragraph
and character styles, or the surrounding text), it's usually not too
difficult to write VBA code that can parse the data out of the document.

If on the other hand the exam documents are created by ordinary Word
users and aren't properly structured, cut and paste may well be the
quickest and cheapest approach.