SQL import date

/***********  导入Excel   Right ---经过测试
SELECT *
FROM OpenDataSource( ’Microsoft.Jet.OLEDB.4.0’,
  ’Data Source="c:/test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0’)..."Sheet1$" Sheet1_

导出文本文件
EXEC master..xp_cmdshell ’bcp "dbname..tablename" out c:/DT.txt -c -Sservername -Usa -Ppassword’
或
EXEC master..xp_cmdshell ’bcp "Select * from dbname..tablename" queryout c:/DT.txt -c -Sservername -Usa -Ppassword’

导出到TXT文本，用逗号分开
exec master..xp_cmdshell ’bcp "库名..表名" out "d:/tt.txt" -c -t ,-U sa -P password’

BULK INSERT 库名..表名
FROM ’c:/test.txt’
WITH (
    FIELDTERMINATOR = ’;’,
    ROWTERMINATOR = ’/n’
)