CSV -> MySQL

[shanesdomainuk]

Tweet

Hi,

I have been playing around with PHP for a bit recently, and was wondering if anyone can help me.

I have a CSV datafeed which i would like to import into a MySQL Database, then once it is there i can learn how to pull off the data.

Can anyone help me?

[uklejon]

I'm not a PHP person but there are tools around that will do this for you i think....try doing a google search for csv to mysql. Others can probably help more with this.

Try this site as well http://www.hkvstore.com/

I use their ASPMaker and can get the bare bones script for data access/search etc up and running in 5 minutes, just have to customise the script from that, and doing it will mean you learn quicker.

Carol

[Frostie]

I got one developed for me, then checked it out myself so I understood how it worked.

To be honest I think just spending a bit of time searching myself and reading up, I could have had it sussed in about 2 hours, but I just didn't have the time.

[999gi]

Take a look at this page

http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html