Hi,

I use SQL Server 2005.

I have used Bulk Insert.

I have put an identity column to the table. Now it looks like this:

Pos item SID

---------- -------------------- -----------

1 tire 1

black 2

50 $ 3

2 car jack 4

blue 5

35 $ 6

3 screwdriver 7

red 8

3 $ 9