6 Replies Latest reply on Feb 24, 2010 9:04 AM by rousselj

    Can I cleanly export data from a query to an Excel format?

    Rookie

      More often than not, my peers and I would like to view the data from our queries in Excel. Unfortunately, we have not discovered a quick way to cleanly export data to a format readable by Excel. For example, exporting a query to XLS takes the liberty of adding formatting to the worksheet. Viewing a query in CSV format is closer to what we want, but it still creates unecessary columns/rows and adds unecessary data like page numbers and the current date. Can anyone suggest a method for cleaning exporting data to Excel?