easiest way to upload a file to a MySql database

Hi Folk

I want my clients to load up a file to a MySql database. The file should
contain rows with

name, email, address, city

What would be the easiest way (in terms of the big picture), to get them to
upload it and put it in a mysql database?

Just let me know if you have any hints on how to go about this? (should
they use excel, or a text file, do you reject the whole file if there is an
error, etc... etc....)

TIA

- Nicolaas

On 2005-07-17, windandwaves <winandwaves@coldmail.com> wrote:[color=blue]
> Hi Folk
>
> I want my clients to load up a file to a MySql database. The file should
> contain rows with
>
> name, email, address, city
>
> What would be the easiest way (in terms of the big picture), to get them to
> upload it and put it in a mysql database?
>
> Just let me know if you have any hints on how to go about this? (should
> they use excel, or a text file, do you reject the whole file if there is an
> error, etc... etc....)[/color]

Read http://dev.mysql.com/doc/mysql/en/load-data.html

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>