Importing CSV files into phpmyadmin
Posted by: G Stewart (---.range81-156.btcentralplus.com)
Date: February 08, 2006 06:37PM

Hi

I am trying to import a Microsoft Excel CSV file (comma delimited) into a MySQL database.

I have created all the necessary tables but when i try to import the file it says:
"You didn't enter any data to import!"

I selected all the relevant CSV options but keep getting that same message.

Please advise!!

Options: ReplyQuote
Re: Importing CSV files into phpmyadmin
Posted by: katsuey (---.kc.res.rr.com)
Date: February 08, 2006 10:50PM

Your MySQL dump statement should look like this:

INSERT INTO `NAME OF TABLE` VALUES (1, 'Testing Calendar', 'Come one, come all. We are going to test this calendar for the Wallula Chuch web site. It''s done with PHP', '2006-01-31 08:00:00', '2006-01-31 20:00:00', 'none');

Of course NAME OF TABLE is the table you are dumping vaule into, then notice that the values begin with a ( , next the first item is the auto number, then each field after gets set between ' ' followed by a comma. End of insert line ends with ) and a ;


Here is a nice tool for uploading data to a database:
[www.webyog.com] There's a free trial and also a free "lite" version.

Options: ReplyQuote
Re: Importing CSV files into phpmyadmin
Posted by: G Stewart (---.range81-156.btcentralplus.com)
Date: February 08, 2006 11:08PM

Cheers for the info! *****

Options: ReplyQuote
Re: Importing CSV files into phpmyadmin
Posted by: katsuey (---.kc.res.rr.com)
Date: February 09, 2006 12:24AM

Hope it helps. I'm not real good at this myself, but happy to share what little info I have since I think WAMP is the best thing since sliced bread.

Options: ReplyQuote


Sorry, only registered users may post in this forum.