Skip to content

Loading and exporting with bcp

Microsoft’s Bulk Copy Progam (bcp) is supported using the text format.


`t.bcp 0:"\t"0:value flip t  / remove column headings


flip cols!("types";"\t")0:`t.bcp /add headings

Pumping data out and inserting it into SQL Server

Create the table in SQL Server if it doesn’t already exist.

Once the table exists in SQL Server:

`t.bcp 0:"\t"0:value flip t
\bcp t in t.bcp -c -T