XLSX to CSV
Posted on 2013-05-17
I have an Access program that generates an .csv file. The problem is, every time I export the date "2013/05/17", it gets converted to "5/17/2013". In Access, I use Format, to force into "yyyy/mm/dd", and if I export it into .XLSX file, the format is fine.
It is when I convert it into .csv that the format change happens automatically.
Since I have to have the end result in .csv, I am not sure what I can do.