stupid question re CSV/phpMyAdmin

mgm_03

I am trying to use PMA to upload data from Excel spreadsheet that has been converted to a CSV text file.

When the file is uploaded, the data appears to be placed in the wrong column ...it's all shifted left by 1 column. I believe this happens because there is, of course, an extra field in the database table for the primary key ...this column does not exist in the spreadsheet data. So, when the file data is inserted into the table, the "company" column data is overwritten by an auto-incrementing primary key integer. And the address info is under the Company column...and so on.

Co_ID .....Company .....Address....City....State.....

So, my question is how do I alter the spreadsheet so that I can save it as a CSV file in which every line starts with a comma. This would accomodate the Co_ID key field. I tried inserting a blank column into the spreadsheet...didn't work.

Ideas? THANKS in advance!

mystrymaster

how are you building your csv file? Through excell? If so simply ad a column in excell before your first column and do not put any data in it that will take care of it for you. Other then that I ran into the same problem and used the above method as my fix.

mgm_03

Thanks for responding.

Not sure why it doesn't work for me ....inserting a blank column.

However if I just put a single space <spacebar> in the first cell of that blank column, then it seems Excel recognizes the column. The the CSV is properly created with all lines beginning with a comma.

If there's nothing in the column, Excel more or less omits the column or doesn't recognize it when converting to a CSV file...hmm