Word + Access DB + need Help

[LittleBird]

Hi,
I should write a Data Base application. but the problem is the data entry of
this database. I have a word document which contains the data that must be
put into the field of this database. Imagine I have a document which has
some signs to recognize which paragraph must be put in which field of the
database. for example my db has 2 fields. Paragraphs starting with # must be
put in field1, and paragraphs starting with ~ character must be put in field
2 of my db. I would like to write a program to do this work for me and by the
way every paragraph may
contains some formulas or Images(small size) in it. by the way, my DataBase
is MS Access, and I use delphi to write program.
Is it possible? what method do you suggest? I would be greatly happy for
each comments, tips that guides me.


-Thanks in advance

 

[Sam Hobbs]

The Word object model has a paragraph object; I think it is a range but you
can find it very easily in the documentation. So I assume you can just read
each paragraph form beginning to end. Note that your definition of a
paragraph might not be the same as Word's definition so you need to do a
little analysis.

You don't explain the relevance of the formulas and images. More
specifically, you do not specify whether they need to be ignored or included
in the database.

 

[LittleBird]

Thank you for your reply.
The formulas and Images should be included in the database. in fact my
document contains chemistry questions with answers of that questions.
questions starting with # and answer of that question in the next paragraph
starting with ~ character. I want to write an application to take a test from
the user. so I thought I should firstly convert these document to a
database, then I'll use them in my application. the position of the formulas
or the images in the text is important to me. because afterwards I want to
read them from database and show them to the user. so during transferring
paragraphs from document to the database and during reading database and
showing the information in my application, the position of these formulas
should not be changed.
In Access should I select Ole for the type of the fields?
would you please give me a link to the necessary documentation? I'm newbie
to this subject.

-Thanks a gain

 

[Sam Hobbs]

I can't help much so I hope someone with more experience will also help.

It might be possible to have an Access field for OLE-style objects. Look at
the Access documentation; it should be possible to answer this question with
a quick look at the documentation. Or you can simply look at what types are
available in the drop-down box of available types when we create a database
field.

There might also be a type for RTF data and it is probably possible to
convert the Word paragraphs to a RTF format.

There might also be a type for HTML data and it is probably possible to
convert the Word paragraphs to a HTML format.

Both RTF and HTML can be stored as plain text so that is an alternative
(last-resort) possibility.

 

[Doug Robbins - Word MVP]

You are really jumping in at the deep end.

You will find some information about moving data from Word to Access in the
last of the articles at:

http://www.mousetrax.com/techpage.html#autoforms

The folks over in microsoft.public.access newsgroups can probably offer you
more advice on the OLE field question.

At this point however, not knowing any more about your "application" and how
you intend to make use of the data if you had it in Access, I could not be
certain that it is even the way that you should be going. Maybe just a two
column table in a Word document with the questions in the first column and
the answers in the second column might be a far simpler approach.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Cindy M.]

Besides the other thoughts... It would be very important to
know which versions of Office you're targeting...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail