The update statement works.

Thanks:)

commas are not part of the data to be imported, just as field separators

code:

bulk insert [prod_inSight].[dbo].[saitemoptions]

from

'j:\imports\items.csv' with (fieldterminator = ',')

Data:

96405,2524-0140076076,"SHEET 4 X 8 5/8"" DBL-SIDED HPL",1,2,EA,NOVA_NT_DOMAIN\dwagoner,39363.34861,NOVA_NT_DOMAIN\dwagoner,39363.60903,39363,65537,1

field three imports as: ...

Using bulking insert from a .csv file. No commas in data.

Thanks