Posted by Erland Sommarskog on 10/14/05 17:46

Mike (noway@forgetit.com) writes:
> 2) Now I get the following error:
>
> ---Begin Error Msg---
> Server: Msg 4864, Level 16, State 1, Line 1
> Bulk insert data conversion error (type mismatch) for row 47, column 3
> (PRICE).
> ---End Error Msg---
>
> This error is repeated for 10 different row from Row 47 to 379 and then
> the import stops because the max error level has been reached.
>
> The columns are configured as follows:
>
> SQL Table-
> Name: PRICE
> Data Type: decimal (28,14)
>
> MS-Access Table
> Name: PRICE
> Data Type: numeric (single w/auto decimal)
>
> The data is export to a CSV text file.

I will have to repeat what I said in my previous 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.

Mind you, I don't know your Access table - in fact I don't know Access
at all.

It's probably a good idea to include the first 50 lines or so in the
file in the post, so anyone who is trying to help you can reproduce the
error.

--
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

[Back to original message]