Topic: Populating MySQL from Excel

Hello everybody,

I use MySQL and PHP. This is the situation:

I have a client with a list of almost 300 email adresses and wants to put that information in a web page I'm creating for her. So, I need to populate a database with the following fields: first name, last name and email adress. What would be the best option for this? I guess an Excel file would be a good choice, but how do I proceed? Does someone have an idea?

Cheers

Eduardo

Vote up Vote down

Re: Populating MySQL from Excel

You can use excel for this but save as a either a comma separated or tab separated text file (.txt). 
If the list she has is already tab separated then you might be able to import using that. might try using a space separated list too because I think you can specify the delimiter using phpmyadmin to import it.

Vote up Vote down

Re: Populating MySQL from Excel

Thanks, I'll try that

Vote up Vote down

Re: Populating MySQL from Excel

I have a client with a list of almost 300 email adresses and wants to put that information in a web page

Email addresses in a web page?? BE CAREFUL - spambots will take them unless you mung (Mash Until No Good) them with javascript or some other way.

Vote up Vote down

Re: Populating MySQL from Excel

Sorry, I didn't mean that.
The client wants to put those mails in a DB associated to her web page. She just wants to send new info about products or news to a mail list of her clients. Those mails will never appear in any visible place of her site.

Vote up Vote down