This is my data in Exmaple.csv
SYMBOL :20MICRONS
SERIES :EQ
OPEN :30.5
HIGH :33.6
LOW :30.5
CLOSE :31.15
LAST :30.55
PREVCLOSE :32.1
TOTTRDQTY :101214
TOTTRDVAL :3286508.05
TIMESTAMP :1-Mar-13
TOTALTRADES:989
ISIN :INE144J01027
this is my Table in sql
Collapse | Copy Code
CREATE TABLE [dbo].[cmpDailyRateMas ter](
[SYMBOL] [varchar](50) NULL,
[SERIES] [varchar](50) NULL,
[OPEN] [real] NULL,
[HIGH] [real] NULL,
[LOW] [real] NULL,
[CLOSE] [real] NULL,
[LAST] [real] NULL,
[PREV] [real] NULL,
[TOTTRDQTY] [int] NULL,
[TOTTRDVAL] [int] NULL,
[TIMESTAMPDAY] [date] NULL,
[TOTALTRADES] [int] NULL,
[ISIN] [varchar](50) NULL
)
Bulk insert csvFile from 'D:\cm02SEP2014 bhav.csv' with
(
FIELDTERMINATOR =',',
ROWTERMINATOR ='\n'
)
now i got error message is Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 3 (OPEN).
...pls give me answer anyone.....
SYMBOL :20MICRONS
SERIES :EQ
OPEN :30.5
HIGH :33.6
LOW :30.5
CLOSE :31.15
LAST :30.55
PREVCLOSE :32.1
TOTTRDQTY :101214
TOTTRDVAL :3286508.05
TIMESTAMP :1-Mar-13
TOTALTRADES:989
ISIN :INE144J01027
this is my Table in sql
Collapse | Copy Code
CREATE TABLE [dbo].[cmpDailyRateMas ter](
[SYMBOL] [varchar](50) NULL,
[SERIES] [varchar](50) NULL,
[OPEN] [real] NULL,
[HIGH] [real] NULL,
[LOW] [real] NULL,
[CLOSE] [real] NULL,
[LAST] [real] NULL,
[PREV] [real] NULL,
[TOTTRDQTY] [int] NULL,
[TOTTRDVAL] [int] NULL,
[TIMESTAMPDAY] [date] NULL,
[TOTALTRADES] [int] NULL,
[ISIN] [varchar](50) NULL
)
Bulk insert csvFile from 'D:\cm02SEP2014 bhav.csv' with
(
FIELDTERMINATOR =',',
ROWTERMINATOR ='\n'
)
now i got error message is Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 3 (OPEN).
...pls give me answer anyone.....