SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Zealot
    Join Date
    Oct 2002
    Posts
    198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    importing data not working

    I am trying to import my data with excel 2003 (CSV), all the other datas were imported with no problems. however, the date didn't get imported.


    In my data base the date is formatted in this form "year-month-day" and in excel its formatted as "mm/dd/yyyy". could that be the problem?

    In excel i couldn't find a way to format it "yyyy-mm-dd".

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    in excel, set the custom format to yyyy-mm-dd

  3. #3
    SitePoint Zealot
    Join Date
    Oct 2002
    Posts
    198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    nm found it.. thanks.

  4. #4
    SitePoint Zealot
    Join Date
    Oct 2002
    Posts
    198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok, I have another problem now. I am importing my file from cvs, mysql only import up to 127 rows there are 73 left from the file. Is there someothing I forgot to set?


Bookmarks

Posting Permissions

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