code_junkie

CSV file. Excel is automatically converting my text to a date. Bad Excel

Nov 11th, 2011
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. "May 16, 2011"
  2.  
  3. "=""May 16, 2011"""
  4.  
  5. SELECT CONCAT(''',NOW(),'''), firstname, lastname
  6. FROM your_table
  7. INTO OUTFILE 'export.csv'
  8. FIELDS TERMINATED BY ','
  9. ENCLOSED BY '"'
  10. LINES TERMINATED BY 'n'
Add Comment
Please, Sign In to add comment