Not shure which query have to use

[ANSWER]

Hi,

I want to make, or is is possible to make database with function to update
words in saved document.
For example, in my database I enter word in German and English, and when
when I press update button I want to German word replace English word in
Selected
document (.doc, .html):
| No | German word | English word |
| 1. | Wagen | Car |
| 2. | Volks | Folks |

......

If this is possible please tell me how should I do this.
Thanks

[Steve]

ANSWER, it would be easiest to do this if your document is regenerated
each time you want to translate. For example, you could read the
document in, place each word in a separate record in a table and use an
update query to change each German record to the English equivalent
(and vice versa). You would then write the changed set of words back
out to the document (i.e. delete/rename old document, create new one
with same name). The drawback is that you'd get a Babelfish-style
mishmash of translated words and non-translated words if your database
didn't have every possible word in one language matched to the other.

Also consider that some words in one language have no meaning at all in
another language.

If this didn't help let me know and I'll draw it out for you.

[ANSWER]

I want to make, or is is possible to make database with function to update
words in saved document.
For example, in my database I enter word in German and English, and when
when I press update button I want to German word replace English word in
Selected
document (.doc, .html):
| No | German word | English word |
| 1. | Wagen | Car |
| 2. | Volks | Folks |
......

If this is possible please tell me how should I do this.
Thanks

------------------------

One of the sollutions,

it would be easiest to do this if your document is regenerated
each time you want to translate. For example, you could read the
document in, place each word in a separate record in a table and use an
update query to change each German record to the English equivalent
(and vice versa). You would then write the changed set of words back
out to the document (i.e. delete/rename old document, create new one
with same name). The drawback is that you'd get a Babelfish-style
mishmash of translated words and non-translated words if your database
didn't have every possible word in one language matched to the other.

Also consider that some words in one language have no meaning at all in
another language.

So could you please help me to draw it.
Thanks