Importing from Word / *.txt problems

  • Thread starter Thread starter Doug Sanders
  • Start date Start date
D

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
 
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).
 
I understand the replacing the checkbox thing.

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

Thanks for your response.

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.


I understand the replacing the checkbox thing.

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

Thanks for your response.

Doug
Click to expand...
 
Thanks,

Doug


John Nurick said:
"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.
Click to expand...
 
Back
Top