5、 master..xp_cmdshell 'bcp dbname..tablename in c:DT.txt -c -Sservername -Usa -Ppassword'/** 导出文本文件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 -Sse
6、rvername -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 = '')--/* dBase IV文件select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','dBase I
7、V;HDR=NO;IMEX=2;DATABASE=C:','select * from [客户资料4.dbf]')--*/--/* dBase III文件select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','dBase III;HDR=NO;IMEX=2;DATABASE=C:','select * from [客户资料3.dbf]')--*/第9页共9页新疆维吾尔自治区人民医院项目组文档--/* FoxPro 数据库select * from openrowset('MSDASQL','Driver=Mic