2007-05-17

SQL: Bulk import

Bulk import (save file.txt as csv): LOAD DATA INFILE 'file.txt' INTO TABLE 'tblFoo' (col1, col2, col3)

or
BULK LOAD IMPORT ('c:\file.txt') INTO TABLE 'tblFoo' (col1, col2, col3)

2007-05-10

SQL Server 2000: make table backup with DTS

  • Right-click the table
    • choose Export Data
  • Choose a destination
    • Server: "nwdsql" and Database: NELausData
  • copy table(s)
  • UserXRef"_bkup" (Destination)

Done, then refresh explorer to view.