BCP syntax

[micang]

SQL 2000

Hi All,

I have tried to look on books online, but for the life of me I can't figure out BCP.

Could someone possibly show me a sample of code to export\import using BCP?

Let's say I wanted to import a txt file having:

"RED","1","May"
"Green",2","Jan"
etc
etc

into a table in SQL with headings:

Colour,ID_No,Month

And for export, would the code be pretty similar?

Any guidance to get me on the right path will be greatly appreciated.

Michael

 

[ptheriault]

look up bulk importing in BOL

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[micang]

Thanks Paul
Will crack on..

Michael

 

[nomadicalloy]

Please look at following link

http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c07ppcsq.mspx

thanks

This is Signature

http://www.xpherion.com/

 

[micang]

Thanks nomadicalloy, much appreciated.

Michael