csv to php to db

[kos]

I have a very large, about 65.000 entries, csv file and I want to parse that file and build a query to insert that data into database. the problem is that when I tried to do it myself I got an out of memory exception; so I thought I was doing something wrong so I checked online for a php script and then I still got the same error (that happened when building the query).

Does anyone know a good csv parser?

tia

[kos]

current status: I've find a class on php classes and finally was able to display the results.
the problem is that I don't have a csv file to get data from but an xls, which I have opened in excel and then export to csv which is the file that I parse with php but the output result is malformed and I can't tell if it's the xls or the excel's export feature that's causing this (see attachment)

*note: in Excel everything looks ok as afar as I can tell..

damn...

[kos]

ok, so I've finally figured it out...thanks to http://www.microsoft.com/sqlserver/en/us/default.aspx and my brother

now running queries

[me super happy]