BCP data import

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

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:

> Format file for 221 text files !!!!!
>
> "John Bell" wrote:
> 

Format file for 221 text files !!!!!

"John Bell" wrote:

> Hi
>
> See Erlands post http://tinyurl.com/yf6z2u
>
> John
>
> "DXC" wrote:
> 

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 option
s
> but still can't figure it out. I keep getting different error messages.
>
> T.I.A