phpMyAdmin - database export problems - WebDeveloper.com Forums

This site is best viewed in a modern browser with JavaScript enabled.

phpMyAdmin - database export problems

Spike201000

Hi All,

I'm trying to export a database from phpMy admin to Excel. Some of my product codes are coming out as dates, whereas others are fine. Eg

[INDENT]09-2196 Exporting as: Sept-96[/INDENT]

[INDENT]09-1036 This one's exporting correctly[/INDENT]

Firstly, why are some codes converting to dates, whereas others are not?

Secondly, is there anything that I can do to prevent this from happening when exporting?

Any pointers would be greatly received. Thanks.

g0dzuki99

Excel is trying to be helpful - since it sort of looks like a date format... change the field type in Excel on the columns to number or text.

Spike201000

Thanks for that. I have tried that, but unfortunately, when this is changed to text format, the code is incorrect. Any way around this?

alexsts

Did you try to export your data as .txt file (delimited) and then when you open it using Excel it will ask you to assign data types for the each field.
There you can choose data type as "text" for the field in question and it should be fine.