Loading and exporting with bcp

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

Export

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

Import

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.
KxSystems/kdb/c/odbc.k

Once the table exists in SQL Server:

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