Windows XP 
Access 2007
I run a job daily on the mainframe which creates an extract file containing over 4 million records which I import into an Access db. I created VBA code so that I can easily do the import everyday (the code formats a couple of fields during the import). Problem is I'm running into records that I believe have invalid ascii characters, and it's causing the process to stop importing when the first such record is encountered. I'm not even getting an error message. I didn't even know I had a problem until someone notified me that the table was missing records. My question is, how can I resolve this problem? The invalid characters are always in the same field. All other fields are okay. Why does access stop importing records when the field has an invalid character? Is there someway to test the field first and replace the invalid character with a space or something? I wouldn't even mind if the entire contents of the field were ignored, as long as the rest of the record is imported, along with the remaining records in the file. Due to the nature of the problem, I'm attaching a zip file which contains the db and 8 sample records from a file to be imported. The invalid characters are in the last field of the last 2 records. The last field begins in column 78.
Reply With Quote
