I am trying to read a flat file as the source file with space as the delimiter. I am using the "SQL Import and Export Wizard", and under the "demilited" , there is the following options:
{CR} {LF} {;} {:} {t} {,} {|}
When I tried to use {CR} (carriage return}, it read in the whole line of course. Is there a way I can read in correctly a flat file with spaces as the delimiters?
Thanks,
{CR} {LF} {;} {:} {t} {,} {|}
When I tried to use {CR} (carriage return}, it read in the whole line of course. Is there a way I can read in correctly a flat file with spaces as the delimiters?
Thanks,
Comment