Posted by Mike on 10/14/05 02:34

Sorry for the double post. I dont know what I was thinking.

I looked for bad data but I did not see any. With the column being set
to numeric and singal in MS-Access, I dont think there could be any non-
numeric data in the column. The only thought I would have is Null values
being in the column but the SQL table is set to allow Null values.

What exactly is a Type Mismatch error? What does it mean? I thought it
might mean I was trying to input non-numeric data into a numeric column,
but I dont see any.

I am stuck...

Mike Charney

Hugo Kornelis <hugo@pe_NO_rFact.in_SPAM_fo> wrote in
news:k0jtk1dd153rcs6fvv6eb5le1rukn57qot@4ax.com:

> On Thu, 13 Oct 2005 20:34:14 GMT, Mike wrote:
>
>>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?
>
> Hi Mike,
>
> My guess is that there's some dirty data in the file you're trying to
> read in.
>
> You might want to double-check the data. And the format file you used.
>
> Best, Hugo

[Back to original message]