bulk insert creating numbers like "3.65257e+006"

  • I am trying to import a large txt file (9 million records) into sql server, some of the fields have large numbers in them, after import, I don't see the numbers, just horrible representations like: 4.01824e+009

    I had made all the fields in the receiving table to be "nvarchar(255)" because I was getting import errors until I changed the expected fields to that (imported file fields may not be perfect)

    I seem to be stuck with getting this file into sql server...is there a better / easier way to get such a file into the database? My command:

    BULK INSERT claimfile FROM '\\localhost\ky\ky1.txt'

    WITH (

    FIELDTERMINATOR = '|',

    ROWTERMINATOR = '')

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply