csv to phpmyadmin

[bufhal]

hello;
I am trying to save an ordinary .xls Excel file as a CSV to upload to
MySQL database via PHP my Admin. The first column I am leaving empt
because I need it to auto-incrment in PHPMYADMIN afetr upload. I canno
save the file-all choices on the message do not work to save the fil
as .csv with the empty column.
Can anyone offer me some insight-step-by-step on how I can simply sav
the file from .xls to .csv so it is ready to upload to phpmyadmin?
When I do upload the file with a "1" in the first record column, onl
one record is uploaded-out of 50.
Any help is appreciated.
;

 

[Dave Peterson]

First, I don't know anything about SQL or PHP.

But are you sure it's excel's problem? I saved some test data with A1 empty as
a .csv file.

Then I opened that .csv file in NotePad and it looked ok to me:

I tried it again with all of column A empty and it still looked ok in the .csv
file:

,4,4,9,9,8,,,,,
,6,7,10,6,10,,,,,
,6,5,7,5,1,,,,,
,5,2,7,9,4,,,,,
,6,4,8,8,2,,,,,
,8,8,8,4,5,,,,,
,9,4,10,10,7,,13.34,8.34,14.34,14.34

 

[bufhal]

Hi Dave;
thanks for the reply.
Can you tell me what options you receive when you save the .xls as
.cvs file?
Should I upload the file in notepad format after I save as csv?
Thank