Importing from Word / *.txt problems

[Doug Sanders]

I have a Word 2000 template that I convert to a txt file to import
data into Access.

Two different areas are giving me problems.

First is a check box that whether it's checked or not does not show
up in the text file. The field label is there, no results though.

Second is similar. It's a drop down box with multiple choices.
Again, the label is in the text file, but no results.

Is the problem in the template, or in the conversion?

I'm making the conversion through Access code.

Thanks for any help.

Doug Sanders

This is a repost from Microsoft. Public.Word.Conversions

 

[John Nurick]

Hi Doug,

This sounds like a limitation in Word's text file conversion routine.
Probably the thing to do is, before converting to text,
1) replace the checkbox with a plain text Y or N (or -1 or 0)
2) unlink the dropdown formfield (thus replacing it with its current
value).

 

[Doug Sanders]

I understand the replacing the checkbox thing.

Need clarification / more detail on unlinking the drop down formfield.

Thanks for your response.

Doug

 

[John Nurick]

"Unlinking" a field deletes the field and replaces it with whatever was
its value. The keyboard shortcut is Ctrl-Alt-F9, and in VBA you use
Selection.Fields.Unlink
ActiveDocument.Fields.Unlink
or whatever.

I understand the replacing the checkbox thing.

Need clarification / more detail on unlinking the drop down formfield.

Thanks for your response.

Doug

 

[Doug Sanders]

Thanks,

Doug

"Unlinking" a field deletes the field and replaces it with whatever was
its value. The keyboard shortcut is Ctrl-Alt-F9, and in VBA you use
Selection.Fields.Unlink
ActiveDocument.Fields.Unlink
or whatever.