how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.
BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>
|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.