Not sure what you're running into here. Embedded text qualifiers are things like having quotation marks inside a column value.
"Bob","Jones","123 "Main" St","MyCity"
The quotes are "Main" are potentially problematic.
123,"Bob","Jones","123 Main St","MyCity"
Shouldn't be a problem. I've imported thousands of such files through DTS and SSIS, where numeric columns don't have qualifiers and text columns do. Used to admin a system that imported 50-100 such files per day, never had a problem with it. Even had to deal with inconsistencies like some files had column 1 with text qualifiers, and other files didn't. So long as it was consistent within each file.
Do you have a sample of the problem data?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon