Programmabilities Blog
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)
Labels: sql
- posted by programmabilities @ 21:53 0 comments links to this post
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.
Labels: sql
- posted by programmabilities @ 18:13 0 comments links to this post
