Import large capacity from remote data files

To import data from other computers using BULKINSERT or INSERT... SELECT * FROMOPENROWSET (BULK...), you must share data files between the two computers. When specifying a shared data file, use its Universal Naming Convention (UNC) name, which is generally in the form of \ ServernameSharenamePathFile

To import data FROM other computers using bulk insert or INSERT... SELECT * from openrowset (BULK...), you must share data files between the two computers. When specifying a shared data File, use its Universal Naming Convention (UNC) name, which is generally in the form of \ Servername \ Sharename \ Path \ File

To import data FROM other computers using bulk insert or INSERT... SELECT * from openrowset (BULK...), you must share data files between the two computers. When specifying a shared data file, use its Universal Naming Convention (UNC) name, which is generally in the form\\Servername\Sharename\Path\Filename. In addition, the account used to access the data file must have the permissions required to read the files on the remote disk.

For example, the following bulk insert statement imports large amounts of data in the data file newdata.txt to the SalesOrderDetail table of the AdventureWorks database. This data file resides in the \ dailyorders shared folder under the salesforce network shared directory of system computer2.

<无>

BULK INSERT AdventureWorks2012.Sales.SalesOrderDetail   FROM '\\computer2\salesforce\dailyorders\neworders.txt';GO