By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 1,005 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

Bulk load data conversion error

P: 2
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].[cmpDailyRateMaster](
[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:\cm02SEP2014bhav.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.....
Sep 4 '14 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.