Problem with bcp tool - SQLFLT8 type can't convert float value correctly
If u created the table like below: CREATE TABLE [dbo].[test]( [test_ID] [char](10) COLLATE Korean_Wansung_CI_AS NOT NULL, [test_TYPE] [char](3) COLLATE Korean_Wansung_CI_AS NULL, [test_NAME] [varchar](30) COLLATE Korean_Wansung_CI_AS NULL, [X] [float] NULL, [Y] [float] NULL, ) and then u don't have FORMAT file... bcp will create it automatically after ensure u... like below.. 9.0 5 1 SQLCHAR 0 1..