Data Export / Import

< < <

Get flash to fully experience Pearltrees

transfer (insert) data from one table to another table

Creating a Format File

To use a bcp command to create a format file, specify the format argument and use nul instead of a data-file path. The format option also requires the -f option, such as:

http://msdn.microsoft.com/en-us/library/ms191516.aspx

database_name

BULK INSERT (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188365.aspx

Using a Format File to Bulk Import Data

http://msdn.microsoft.com/en-us/library/ms178129.aspx

The examples in this section illustrate how to use format files to bulk-import data by using the bcp command and the BULK INSERT, and INSERT ...

Data Export / Import

transfer (insert) data from one table to another table

Creating a Format File

BULK INSERT (Transact-SQL)

Using a Format File to Bulk Import Data

Understanding Non-XML Format Files