|
|
Posted by Mike on 10/13/05 23:34
Ok I fix those now I have the following error
---Begin Error Msg---
Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 1, column 14
(STDCOST).
---End Error Msg---
The STDCOST is set to decimal (28,14) and is a formatted in Access as a
number, single with 14 decimal. I don't know why I would be getting a Type
Mismatch error.
Any idea?
Mike
"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:a3etk1hrq4v7odfrk71r0hli5lfivqebgt@4ax.com...
> On Thu, 13 Oct 2005 19:35:16 GMT, Mike wrote:
>
>>I have the SQL table column PRICE set for decimal (14,14).
>
> Hi Mike,
>
> That means that you have a total of 14 digits, 14 of which are to the
> right of the decimal. Leaving no digits to the left.
>
>>Any one know why I would get an overflow error.
>
> Probably because there's a value above 1.000 or below -1.000 in your
> data.
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)
Navigation:
[Reply to this message]
|