SQL Server 2000 Data Import and Export

Data export and import

Bulk Copy Program (BCP)

• Syntax

  BCP {[[database_name.][owner].]{table_name | view_name} | "query"}
      {in | out | queryout | format} data_file
       [-m max_errors] [-f format_file] [-e err_file]
       [-F first_row] [-L last_row] [-b batch_size]
       [-n] [-c] [-w] [-N] [-V (60 | 65 | 70)] [-6]
       [-q] [-C code_page] [-t field_term] [-r row_term]
       [-i input_file] [-o output_file] [-a packet_size]
       [-S server_name[\instance_name]] [-U login_id] [-P password]
       [-T] [-v] [-R] [-k] [-E] [-h "hint [,...n]"]
  

• Import Example

  bcp Northwind.dbo.Employees in c:\temp\addemploy.txt -c -T
  

• Export Example

  bcp Northwind.dbo.Employees_Export 
      out c:\temp\export.txt -c -T
  bcp Northwind.dbo.Employees_Export  
      out c:\temp\Export_Comma.txt -c -t, -r\n -T