dcsimg
www.webdeveloper.com
Results 1 to 4 of 4

Thread: phpMyAdmin - database export problems

  1. #1
    Join Date
    Dec 2010
    Posts
    32

    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
    Posts
    37
    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.

  3. #3
    Join Date
    Dec 2010
    Posts
    32
    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
    Location
    Discworld
    Posts
    75
    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.

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



Recent Articles