Found this on Experts Exchange for
BCP.exe (don't know if you use this or the
BulkCopy
command)
-- You could create a view with the appropriate replacements and bcp from that
create view v_products
select
ProductID,
ProductName,
replace(convert(varchar,UnitPrice),'.',',') UnitPrice
from Northwind.dbo.products
Another option might be to use the -R option:
Quote:
-R
Specifies that currency, date, and time data is bulk copied into SQL Server using the regional format defined for the locale setting of the client computer. By default, regional settings are ignored.
More information here:
bcp Utility[
^]