the problem is I can't post any data for security purpose. But I do appreciate your help. I got it work, but just not the way I expected. So maybe...

Thanks, Jeff. right now I wrote a console app to reformat the files to tab delimited files and the problem is fixed. but the performance is getting worse. I have...

By "map out the column lengths" do you mean make it a fixed length file?

Thanks for all the inputs! Yea, I am working on reformatting the data. I was hoping that I don't have to do that...

Thanks for your quick response. I guess I didn't state the problem clearly. In my case, I don't want the data imported as two seperated fields: "toys ""r"" us" and...