Import From excel

I have an excel file with 11000 lines
I made up a column for numbering the rows, e.g. 1,2,3,4,5,6...11000

I migrate this excel into table for sql 2000
While i use the custom built and specify order by record,
this gives me sth like that : 1,2,3,4,5,6...100..101, 1011,1012, ,120,121....

I see that I parsed them as floats can this be the issue?
Or should I do sth else wrong?Despite the fact in the procedure I created the select with order by record which record is 1,2,3,4,5,6 and I have it as integer,
unless I export the data to excel and re-import from excel, the records from a simple select popup as they like...and not by record order...

I hope someone has dealt with that in the past...help?sql