Page 1 of 1

Datatype changes when exporting to Excel

Posted: Tue May 06, 2014 5:45 am
by Martin

Hi,
When I export some adresses to an excelsheet, the housenumbers (original datatype = varchar(255) ), the datatype of the housenumbers sometimes changes to datetime type.
For example : Dorpsstraat 4-6 will be exported as Dorpsstraat 4-jun
What can I do to achieve a correct exportfile?
Thanks, Martin.


Re: Datatype changes when exporting to Excel

Posted: Tue May 06, 2014 10:56 am
by mobhar

Did you use "PHPExcel" extension?


Re: Datatype changes when exporting to Excel

Posted: Mon May 12, 2014 6:19 am
by Martin

Thanks Mobhar, this was were it went wrong.
Great help, problem solved.