Find record causing failure on Insert statement

[ms]

I am running an insert statement from a dbf file and there is one record causing
the insert to fail. A msg. is returned stating it is due to an invalid
datatype. There are 2 text fields, 2 numeric(double), and one date/time. I
assume it is one of the numeric or the date/time field. How can I determine the
culprit record?
There is one key field which is one of the text fields.
I am trying to write a JOIN query but have not been successful.
The insert statement is:
INSERT INTO stageItemDMD ( ItemNo, Demand, Issued, ActionBy, ActionType )
SELECT Item_Numbe, Supply_Dem, Issued_Sup, Action_Req, Action
FROM dbf_dmd;
thanks for any advice.
mark

[Squirrel]

Could you load the data you're trying to insert into a recordset and then
loop through the recordset, inserting one record into the destination table
on each pass? Maybe have the recordset be sorted so that when the insert
fails you'll be able to look at the records that made it into the
destination table and you'll be able to see where the failure occurred in
the sorted source records...
"ms" <[e-mail]> wrote in message
news:n6********************@comcast.com...

I am running an insert statement from a dbf file and there is one record causing the insert to fail. A msg. is returned stating it is due to an invalid
datatype. There are 2 text fields, 2 numeric(double), and one date/time. I assume it is one of the numeric or the date/time field. How can I determine the culprit record?
There is one key field which is one of the text fields.
I am trying to write a JOIN query but have not been successful.
The insert statement is:
INSERT INTO stageItemDMD ( ItemNo, Demand, Issued, ActionBy, ActionType )
SELECT Item_Numbe, Supply_Dem, Issued_Sup, Action_Req, Action
FROM dbf_dmd;
thanks for any advice.
mark