Results 1 to 2 of 2
  1. #1
    louise is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    112

    Export query results for .csv with bold, italics, and paragraph breaks

    Hello,


    I have an Access field that includes a course description. it must have some words made bold, others in italics, and paragraph breaks, so I made the field a .rtf field. But, I need to export the query results that include this field it to a .csv file to be uploaded to our website, and the .rtf text does not convert correctly.

    Before I needed bold, etc., I successfully did this by exporting to Excel and saving as a .csv file. But that has failed -- the bold and italics do not carry through to the .csv file. .

    Can you give me some hints about what to try next?

    thanks!

  2. #2
    llkhoutx is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Convert the rtf fields to plani text before exporting. Take a look at http://tinyurl.com/p7m9ujh

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 20
    Last Post: 03-13-2014, 12:50 PM
  2. Export Fixed Width with No Line Breaks/Carriage Returns
    By jpfulton248 in forum Import/Export Data
    Replies: 5
    Last Post: 01-17-2014, 12:41 PM
  3. Replies: 3
    Last Post: 01-07-2014, 03:39 PM
  4. Replies: 1
    Last Post: 04-30-2012, 05:10 PM
  5. Export Access reports/query results to Outlook Calendar/Task
    By kfinpgh in forum Import/Export Data
    Replies: 0
    Last Post: 02-22-2007, 01:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums