Pardon, can someone tell me how to resolve and "error 0xC0202092" ?
I am trying to import a text file, with "" as the field text qualifier.
Thanks,
`LeAlright, I have narrowed the error, but not the solution.
The problem occurs when importing a text file using TEXT DELIMITERS.
Specifically, imagine these two records (Text qualifier of "" and field delimeter of "|"):
"Row 1"|"Hello Nurse"|"Goodbye"
"Row 2"|"Hello Jenna"|"Goodbye"
In the 2nd row, there are several spaces after the word "Goodbye". These spaces are causing the import problem!
This error does not appear in SQl Server 2000!
Anyone have a solution?
`Le
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment