I think it is good practice whenever feasible to load data into a staging table first. The staging table is set up to apply the absolute minimum restrictions on the data that it will accept. IE, anything will go into the staging table. The data is then cleansed and loaded into the primary database schema, and all succesfully loaded records are deleted from the staging table. This makes it easy to identify what values are causing the error.
Here are the files that are associated with this problem.
picupload.asp -- the form where data is entered. POST to Insert.asp
insert.asp -- has include at top of file to loader.asp Then has form that POST to write2DB.asp
loader.asp -- this is where I think the data is getting screwed up.
write2DB.asp -- INSERT statement. I have text in some of the variables for testing purposes. The CustID and CID are working fine. Notice I had to use CLng function on them to get them working. I can't figure out what to apply to the text fields to make them work.