title: Saving XLS file using SELECT INTO OUTFILE command in mysql
body: <p>im using SELECT INTO OUTFILE query with XLS file as</p>
  
  <pre><code>"SELECT * INTO OUTFILE " . "myfile.xls" . " FIELDS TERMINATED BY '\t'  LINES TERMINATED BY '\n' FROM transactions where ppno like '%$cid%' 
  </code></pre>
  
  <p>Im using XLS file instead of CSV. Is there anything wrong with that. When i try to open that XLS file in Microsoft Excel it says 'The file is in different format, Are you sure you want to open'...  Plz suggest me</p>