 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / June 2007Importing from Word / *.txt problems
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 have a Word 2000 template that I convert to a txt file to import > data into Access. [quoted text clipped - 16 lines] > >This is a repost from Microsoft. Public.Word.Conversions -- John Nurick [Microsoft Access MVP] Please respond in the newsgroup and not by email. I understand the replacing the checkbox thing. Need clarification / more detail on unlinking the drop down formfield. Thanks for your response. Doug > Hi Doug, > [quoted text clipped - 29 lines] > > Please respond in the newsgroup and not by email. "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. > [quoted text clipped - 37 lines] >> >> Please respond in the newsgroup and not by email. -- John Nurick [Microsoft Access MVP] Please respond in the newsgroup and not by email. 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 [quoted text clipped - 48 lines] > > Please respond in the newsgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.