Actually it should import in row order if there is no clustered index. Are you expecting to "select" the data and get it back in this order? There is no guarentee of this. If this is what you want, add an identity column to your table, import into it and select by the identity column.

Steve Jones

sjones@sqlservercentral.com

http://qa.sqlservercentral.com/columnists/sjones

http://www.dkranch.net