|
|
Posted by Erland Sommarskog on 10/14/05 00:23
Mike (noway@forgetit.com) writes:
> I am getting a type mismatch error when I do a bulk insert.
>
> ---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?
No. Telepathy is not my strong side. Please post:
1) CREATE TABLE for the table you are importing into.
2) The BULK INSERT command.
3) A sample data file (please zip into an attachment, to avoid transport
damages).
4) Any format file you are using.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|