CSV Files

[aberry]

Hi,

I am using VB to export records from a MySQL database to a CSV file so that the file can then be used in Excel in other parts of the business.

However, when I open the resultant file in Excel it translates the 02/1 text field to a date which I dont want it to do. I've tried with and without double quotes.

Anyone got any ideas?

Thanks,

Andrew

 

[arst06d]

you can either format the destination column cells as Text before you import the file (Format>Cells)
OR
when exporting, add an ' before the data. Excel translates this as being a text field. eg '02/1