PHPMyAdmin & CSV File: automatic numbering not sequential

[erb5]

I have managed to upload an Excel exported CSV file to MySQL via phpmyadmin, but the automatic numbering of my id field is a little wonkey. It starts out find, going from 1 and to about 600, then jumps to ~77000. I a) don't know why it would do this and b)don't know if this matters anyway. I tried uploading the file a couple times and besides a change in the number where it "jumps," it continues to do so.

There are currently about 1600 records in the CSV. I read somewhere that if you have a lot of records, you might want to break them up into several uploads; what exactly is "a lot"?

TIA.

[erb5]

I think I've "resloved" the issue (as it turns out, I think I may have created it, too).

I added a column at the begining for the autonumbered field and put a 1 in the first entry (all the others I left blank). Then, I checked the tab delimited file Excel created before uploading. It had added a lot of empty lines to the end (I'm not particularly good with Excel either and seem to have added lots of blank lines to the end of the spreadsheet which deleting doesn't actually seem to remove).

After fixing these two things, I uploaded the file and everything worked fine. My autonumbered fields are now appropriately numbered, if it matters. Any other insight or advice is still greatly appreciated. Thanks.

[coopster]

What more could we offer? Seems you've briged the gap!
Welcome to WebmasterWorld, erb5 :)