I am trying to use the bulk insert command but I am getting the following
error:

---Begin Error Msg---
Server: Msg 4867, Level 16, State 1, Line 1
Bulk insert data conversion error (overflow) for row 1, column 3 (PRICE).
---End Error Msg---

The data is formatted as a number, single with 14 decimal. I am exporting
to csv txt file from MS-Access.

I have the SQL table column PRICE set for decimal (14,14).

Any one know why I would get an overflow error.

Mike
m charney at dunlap hospital dot org

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

[quoted text, click to view]

[quoted text, click to view]

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.

[quoted text, click to view]

Probably because there's a value above 1.000 or below -1.000 in your
data.

Best, Hugo
--

[quoted text, click to view]

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

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:

[quoted text, click to view]