Excel Help please

Discussion in 'Programming' started by Egrabber, May 17, 2008.

0
  1. #1
    I have loads of CSV files that are well over 65,500 entries and my old version can not open files larger than 65,500 entries.

    I need a way to open them so i can get all entries some have 200,000 + in them i tried eveything i can think of but without any luck.

    Can anyone please help a novice in very very east step by step guide as to get the full list from the CSV file please.

    Thank you
     
    Egrabber, May 17, 2008 IP
  2. gauravgrt

    gauravgrt Peon

    Messages:
    2,035
    Likes Received:
    129
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Which is the version of you excel?
     
    gauravgrt, May 17, 2008 IP
  3. mrphp

    mrphp Well-Known Member

    Messages:
    682
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    110
    #3
    try to use the latest excel 2007 or make a php script that will display all the contents of your csv.

    if you ever need someone to extract the contents of your csv files and save to a database,
    just pm me and ill be happy to assist you but there's a professional fee.

    Let me know if you're interested.

    Regards,
    Mark
     
    mrphp, May 18, 2008 IP
  4. einsteinsboi

    einsteinsboi Well-Known Member

    Messages:
    1,122
    Likes Received:
    76
    Best Answers:
    0
    Trophy Points:
    140
    #4
    One way to solve your problem would be to split the csv file into sizes that Excel can handle.

     
    einsteinsboi, May 19, 2008 IP