Re: Word documents from records in csv file?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Why would it be too much for several records? In Excel, each record is a row, and each variable is a column. You open the csv file, and presto... If you then want it in Word format, copy the data to the clipboard and paste it into Word. It's fast and efficient. I don't see where the difficulty lies.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Susan" <dsnsacree@xxxxxxx> wrote in message news:Oq1$$pX$HHA.3916@xxxxxxxxxxxxxxxxxxxxxxx

Thanks. It will work for one record but would be too much for several records.

"Herb Tyson [MVP]" <herb@xxxxxxxxxx> wrote in message news:OS$biiU$HHA.5360@xxxxxxxxxxxxxxxxxxxxxxx
If I needed to have the csv file in Word format, I would open the file with Excel, copy the resulting columns/rows to the clipboard, then paste into Word (to produce a Word table), then save in Word format.

You could do everything using Word (e.g., using mailmerge, and sending the output to a file; or using find/replace), but using Excel as an intermediary strikes me as easier. If you plan to use the resulting file as a data file, in fact, you might simply leave it in Excel format, and not bother converting it to Word.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Susan" <dsnsacree@xxxxxxx> wrote in message news:OqD1XqT$HHA.4568@xxxxxxxxxxxxxxxxxxxxxxx
If you have a csv file and you would like to create a standardized word document for a record in the csv file, how would you do that? Can anyone point me in a direction to start reading? If there a way to set up a word document to pull fields for entries from another file? Or maybe there is another MS product to explore?

Thanks,
Susan





.

Relevant Pages

  • Re: CSV import, excel corrupts data
    ... I guess if you want to use excel, you'll have to play by its rules. ... If opening .csv files directly doesn't work for you, ... Doing the macro trick corrupts the data as described when the file is a ... empty worksheet, use the data import wizard to select the csv file, ...
    (microsoft.public.excel)
  • Re: CSV import, excel corrupts data
    ... It _does_ bring up the data import wizard. ... There really seems to be no way to accomplish this in excel. ... Doing the macro trick corrupts the data as described when the file is a ... empty worksheet, use the data import wizard to select the csv file, ...
    (microsoft.public.excel)
  • Re: Basic Program to Import a CSV file
    ... Given that the OP asked about importing a CSV file into UV, ... some Excel to MV tool to import a CSV file into UV? ... Hey, why stop at replacing the database, replace the spreadsheet tools ... The directory file may well be UV ...
    (comp.databases.pick)
  • Re: On File open - how to stop conversion of postcodes to numbers
    ... definite failing of Excel to anticipate correctly the programmers wishes. ... a space before every entry in the postcode field before the first number just ... I could write an automated macro to run the file wizard but I would forever ... When I open CSV file using Notepad the field contains "00037" so it is all ...
    (microsoft.public.excel.worksheet.functions)
  • Re: CSV import, excel corrupts data
    ... If you rename your .csv file to .txt, you can have complete control over each ... field--you can choose Text for the fields that excel thinks are dates (but ... Now Excel utterly corrupts the data and displays some numeric ... its type from standard to text and finally confirm the import at cell A1. ...
    (microsoft.public.excel)