Jump to content

Populating MySQL from Excel


edoplaza

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...