Re: Saving Form Data Only as Plain Text File for Importing into Database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Doug Robbins (dkr_at_NOmvpsSPAM.org)
Date: 09/20/04


Date: Mon, 20 Sep 2004 05:40:17 -0400

That is the way it is intended to work. The data is saved in comma
separated value (csv) format so that it can be imported into a database.

What were you wanting to do with the data?

-- 
Please respond to the Newsgroup for the benefit of others who may be 
interested.   Questions sent directly to me will only be answered on a paid 
consulting basis.
Hope this helps,
Doug Robbins - Word MVP
"Steve L" <steve@leadingchange.net> wrote in message 
news:267256b8.0409191609.7c6ae2a@posting.google.com...
> Sabrina,
> I have done exactly as you have.  I created a Word document, used the
> Forms toolbar to introduce fields, filled out a sample form to test
> it, did a "save as..." using the option to save only data from forms,
> and got a text only file.  But when I open the text file created by
> Word with the forms data, the file does not have tabs and returns in
> the proper places.  Data from several form fields have run together
> into one "paragraph".
>
> Does anyone know what I might be doing wrong, or how to fix it?
> FYI, I am on a Macintosh, system OS 10.3.5, using Word in Office X,
> service release 1.
>
> Thanks,
> Steve Levin
> (I would appreciate receiving a copy of replies at my email address,
> steve@leadingchange.net)
>
>
>
> "Doug Robbins" <dkr@NOmvpsSPAM.org> wrote in message 
> news:<unkkn9QnEHA.3968@TK2MSFTNGP11.phx.gbl>...
>> Please Fill Out This Form
>> Part 1: Create professional looking forms in Word
>> http://www.computorcompanion.com/LPMArticle.asp?ID=22
>>
>> Part 2: Adding Automation to your Word forms.
>> http://www.computorcompanion.com/LPMArticle.asp?ID=46
>>
>> Part 3: Learn more VBA (macros) to automate your forms.
>> http://www.computorcompanion.com/LPMArticle.asp?ID=119
>>
>> Part 4: Use custom dialog boxes in your Word forms
>> http://www.computorcompanion.com/LPMArticle.asp?ID=127
>>
>> Part 5: Connect your AutoForm to a database to save input time and keep
>> better records!
>> http://www.computorcompanion.com/LPMArticle.asp?ID=136
>>
>>
>> -- 
>> Please respond to the Newsgroup for the benefit of others who may be
>> interested.   Questions sent directly to me will only be answered on a 
>> paid
>> consulting basis.
>>
>> Hope this helps,
>> Doug Robbins - Word MVP
>> "Sabrina Brown" <anonymous@discussions.microsoft.com> wrote in message
>> news:270d01c49cf0$2c5be300$a401280a@phx.gbl...
>> > Hi -
>> >
>> > I have created a form in Word 2002 to collect data
>> > electronically that can then be imported into a database.
>> > Exporting the data from Word is a two step process:  (1)
>> > under Tools and Options, choose Save Form Data Only, then
>> > (2) under File, choose Save Copy As file type Plain Text.
>> > This process should save the form data in a comma
>> > delimited format that can then been imported into Access.
>> > Unfortunately, when I do the procedure just described, a
>> > file is not created.  Do you have any idea what the
>> > problem is?  (FYI, I have successfully used this feature
>> > on an earlier version of Word, not Word 2002.)
>> >
>> > Thanks for your help! 


Relevant Pages

  • Re: Protel 2004 answer to Brad Velander.
    ... Sorry, you misunderstand me, I mean to say that jump from 99SE to 2004 XP ... you don't have the same format with one database will all the documents. ... Well you said that you can export file format more recent than AUTOCAD 14 ... key/mouse click you press because I don't know how to do that with Protel ...
    (sci.electronics.cad)
  • Re: Hidden VBA Code
    ... This will display the code module for the item clicked. ... There was a Comma button on my Add-Ins menu, and it would display the "Hi" ... spreadsheet out for my contact to work on it. ...
    (microsoft.public.excel.programming)
  • Re: Combo box not finding record... sometimes
    ... Try the Format option last. ... Private Sub cboLnNum_AfterUpdate ... when I change the data type from Double to Long Integer the database ...
    (microsoft.public.access.formscoding)
  • Re: Error Message: Cant find Installable ISAM
    ... The database is residing on my machine, ... Error Message = "Couldn't find Installable ISAM" ... Connect property set = Access ... Access 2002/2003 format and tried this as a possibility, ...
    (microsoft.public.vb.database)
  • Re: Controlsource wont let Dlookup to enter
    ... MOST US systems/computers default to a comma and I believe many other countries default to a semi-colon. ... Frustrated from entering the expression manually, using the syntax suggested in all the books and websources, I entered the builder of the ControlSource and clicked the Dlookup function from the list of functions. ... You might have to rebuild the form or you might need to decompile your database. ...
    (microsoft.public.access.gettingstarted)