bcp AdventureWorksDW2014.dbo.MyCustomer format nul -c -x -f MyCustomer.xml -t \t –T
bcp AdventureWorksDW2014.dbo.MyCustomer format nul -c -f MyCustomer.fmt -t \t –T
bcp AdventureWorksDW2014.dbo.MyCustomer out MyCustomer_exp.txt -T -c -t \t -r \n
bcp AdventureWorksDW2014.dbo.MyCustomer in MyCustomer_exp.txt -T -f \MyCustomer2.fmt

USE [AdventureWorksDW2014]
GO
DROP TABLE [dbo].[MyCustomer]
GO
CREATE TABLE [dbo].[MyCustomer] (
	[ID] [int] NOT NULL,
	[FirstName] [varchar](20) NOT NULL,
	[LastName] [varchar](50) NOT NULL,
	[BirthDate] [date] NOT NULL,
	[Salary] [decimal](8, 2) NOT NULL,
	CONSTRAINT [PK_MyCustomer] PRIMARY KEY([ID])
)
GO

BULK INSERT [dbo].[MyCustomer] FROM 'MyCustomer.txt'
WITH (
	CODEPAGE = 'ACP',
	DATAFILETYPE = 'char',
	KEEPIDENTITY,
	TABLOCK,
	FIRSTROW = 2,
	-- FORMATFILE = 'MyCustomer.xml',
	FORMATFILE = 'MyCustomer.fmt',
	ERRORFILE = 'MyCustomer.err'
)
GO
SELECT * FROM [dbo].[MyCustomer]
GO