creating a csv to import data
Posted: Thu Jan 18, 2007 9:02 am
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
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