Copying data across

[rkbnair]

What is the syntax to copy the data from a table "mytable" to a plain text
file delimited with tab?

Also, how can import the same data back?

Should we use the BCP utility? If so, what syntax?

Thanks

[Neil Pike]

Use BCP and the syntax is in the docs

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (428 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
or www.ntfaq.com/sql.html
or www.sql-server.co.uk
or www.mssqlserver.com/faq

[rkbnair]

Hi Neil,

Thanks for the message. I went to the site which u mentioned and still couldn't
work out why I cannot run the bcp utility. It accepts the command and goto
an infinite process

This is the command I typed in the Query analyzer.

[master].[dbo].xp_cmdshell "bcp tbl_clients out clients.txt"

Thanks


Neil Pike <neilpike@compuserve.com> wrote:
>Use BCP and the syntax is in the docs
>
> Neil Pike MVP/MCSE. Protech Computing Ltd
> (Please reply only to newsgroups)
> SQL FAQ (428 entries) see
> forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip
- L7
>- SQL Public)
> or www.ntfaq.com/sql.html
> or www.sql-server.co.uk
> or www.mssqlserver.com/faq
>
>

[Neil Pike]

The docs I mention are the SQL Books Online. Look up BCP in that and run it
from a command prompt - if you get the syntax wrong it will tell you. For a
start you need to specify a userid/password to connect with....

> Thanks for the message. I went to the site which u mentioned and still
couldn't
> work out why I cannot run the bcp utility. It accepts the command and goto
> an infinite process
>
> This is the command I typed in the Query analyzer.
>
> [master].[dbo].xp_cmdshell "bcp tbl_clients out clients.txt"
>
> Thanks
>
>
> Neil Pike <neilpike@compuserve.com> wrote:
> >Use BCP and the syntax is in the docs
> >
> > Neil Pike MVP/MCSE. Protech Computing Ltd
> > (Please reply only to newsgroups)
> > SQL FAQ (428 entries) see
> > forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip
> - L7
> >- SQL Public)
> > or www.ntfaq.com/sql.html
> > or www.sql-server.co.uk
> > or www.mssqlserver.com/faq
> >
> >
>

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (428 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7 -
SQL Public)
or www.ntfaq.com/sql.html
or www.sql-server.co.uk
or www.mssqlserver.com/faq