Import data to table

I want to import data to the table of a form i have created. The data is in excel format. I convert it to csv and from there i use this utility (http://www.sqldbu.com/eng/sections/tips/mysqlimport.html) to covert it to SQL format to make the import through PHP my Admin.

Question

Does the name of the file of the data to import must have the same name with the name of the table of the form?

Hi Topdim,

I don't remember but it doesn't matter greatly - you can always change the name of the table after the dat ais imported.

Bob

Another q i have is if the excel file from which i made the csv must i have format suitable so that it can be imported to the database.

What the format must be?
For example do have to name any columns as "text_1" or "text_2" in order to achieve compatibility with the database naming in PHPmy Admin?

Hi topdim,

The column titles must be valid MySQL column names and they may need to match up with field names in your form.

The main rules are no spaces or special characters other than _ and they should start with a letter, not a number.

Bob

Do you know any good tutorial regarding the issue? Any link would be helpfull since it is the 1st time i do this.

I mean the way the excel file must be.

Hi Topdim,

try to import it to any table in your mysql database then match the columns names as Bob suggested, this is how I did it before and I'm not sure if there is an easier way!

Regards,
Max