2 Replies Latest reply on Apr 24, 2007 1:58 PM by tbaggz

    Saving Query as xls file (I have searched and havent found this problem)

      I am trying to save a query as a xls file. The user can currently save the file to there desktop but excel warns them upon opening it that the file is associated with a different type of file do you want to continue. if you choose to continue then it will open up fine. so it kind of works. How can i get around this? i can't output it as a csv because there is comma's in some of the data i am outputting, and if i do a tab delimited then it is associated with notepad by default. here is my code:
      thanks, Drew