Add And Delete Queries updating client records are not working correctly

[ChrisAccessDB01]

We have a rather large amount of information in our access DB we use an automatic update macro thats activated by the user via a button
this macro activats another macro which Uses the Transfer Spreadsheet function to transfer files from EXCEL into a TABLE call it (Imported FRom Excel Trimmed) .

the original macro then runs a delete query that deletes the contence of another table (that is usually empty anyway) then an add querygets the contence of Imported FRom EXCEL Trimmed and appends it to the appropriate field names No to No and NINO to NINO etc
then another delete query is ran to delete the contence of the main destination table this clears it and perpares it for the new data. then imported from excel trimmed is imported into client records and job done.

this is the proceedure
but unfortunatly the macros dont tend to import all the results, they miss out loads and i dont know why. i thought data types but i have checked the data types and constrains on the tables

can this be done in another way a simpler way perhapse with an update insted of a[ppend query

your ionput would be appreciated
thanks
chris

 

[Ziggy1]

look at the tables you are appending to...change all the fields ( unless you want to figure out which one) to "Allow Zero Length" in the field properties.
You should test this with one table...I can almost guarantee this is your problem...I've been down this road.

I think another way is to set a default value in the fields

 

[ChrisAccessDB01]

oh that's excellent yes that does solve the problem thanks a lot