[AccessD] append query error count

Screen shot is the easiest way. <grin>

But you should clean up your data before trying to append it to a table.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: lyle.hannum at co.wake.nc.us [mailto:lyle.hannum at co.wake.nc.us] 
Sent: Thursday 2003 Feb 27 14:43
To: accessd at databaseadvisors.com
Subject: [AccessD] append query error count

Hi

When running a append query you may occasionally generate a Access
msgbox similar to: "Microsoft cant append all the records in the append
query. Microsoft set 17 field(s) to null due to a type conversion
failure..." Does anyone know how to capture the number and type of
append failures? TIA

Lyle Hannum