Page 1 of 1

creating a csv to import data

Posted: Thu Jan 18, 2007 9:02 am
by hame22
Hi I am creating a excel csv file to import some data into a table through phpmyadmin.

I have some questions regarding this.

In my excel file do I have to have a column for each table field, I am only inserting to half of the fields as the other half are automatically generated.

The table that I am importing into has a field which automatically generates a unique primary key - do I leave this field out from the csv?

I would appreciate any tips, thanks in advance

Posted: Thu Jan 18, 2007 10:34 am
by Kieran Huggins
I remember phpMyAdmin being picky about CSV importing.

Export some data from phpMyAdmin as CSV and follow that format

Posted: Thu Jan 18, 2007 12:45 pm
by dibyendrah
This URL will also help you regarding loading csv and other text files.
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html