|
|
|
| Anyone knows what is the syntax for BCP import for a comma delimited and
double quote text qualifier text file ? I have tried almost all the options
but still can't figure it out. I keep getting different error messages.
T.I.A
| |
| John Bell 2006-11-30, 7:14 pm |
| Hi
You can use BCP with the format option to get a format file that you can
change. Alternatively look at using DTS/SSIS see
http://www.sqldts.com/default.aspx?246
John
"DXC" wrote:
[color=darkred]
> Format file for 221 text files !!!!!
>
> "John Bell" wrote:
>
| |
|
| Format file for 221 text files !!!!!
"John Bell" wrote:
[color=darkred]
> Hi
>
> See Erlands post http://tinyurl.com/yf6z2u
>
> John
>
> "DXC" wrote:
>
| |
| John Bell 2006-11-30, 7:14 pm |
| Hi
See Erlands post http://tinyurl.com/yf6z2u
John
"DXC" wrote:
> Anyone knows what is the syntax for BCP import for a comma delimited and
> double quote text qualifier text file ? I have tried almost all the options
> but still can't figure it out. I keep getting different error messages.
>
> T.I.A
|
|
|
|