Microsoft SQL Server - bcp (bulk copy program) Utility - MS SQL Server Full Tutorial

MS SQL Server - Microsoft SQL Server - bcp (bulk copy program) Utility

Start

Start
Example to Import Data without a Format File(using Native Format ) `REM Truncate table (for testing) SQLCMD -Q "TRUNCATE TABLE TestDatabase.dbo.myNative;" REM Import data bcp TestDatabase.dbo.myNative IN D:\BCP\myNative.bcp -T -n REM Review results SQLCMD -Q "SELECT * FROM TestDatabase.dbo.myNative;"`

Example to Import Data without a Format File(using Native Format )

REM Truncate table (for testing)
SQLCMD -Q "TRUNCATE TABLE TestDatabase.dbo.myNative;"

REM Import data
bcp TestDatabase.dbo.myNative IN D:\BCP\myNative.bcp -T -n

REM Review results
SQLCMD -Q "SELECT * FROM TestDatabase.dbo.myNative;"

Read Article
https://develop.horje.com/learn/1434/reference