>Looking into the text file, I noticed that the problem records are missing a field or two delimited by "". So I imagine that is the reason for the misalignment of the columns. But why does the import wizard handle this while the append statement does not?
>
In the Wizard, there should be a check box when you define the delimiters that refers to how to deal with consecutive delimiters, as in your case.

I thought that the Wizards where now allowed to be included in developed programs.