Results 1 to 4 of 4

Thread: phpMyAdmin - database export problems

Hybrid View

  1. #1
    Join Date
    Dec 2010

    phpMyAdmin - database export problems

    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

    09-2196 Exporting as: Sept-96

    09-1036 This one's exporting correctly

    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.

  2. #2
    Join Date
    May 2012
    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.
    "A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools."
    -- Douglas Adams

    Have you minified your CSS/JS lately?

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

  4. #4
    Join Date
    Mar 2006
    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.

    Please consider the
    environment before printing

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center