• λ我爱Aspx >> C#.Net >> 求个Excel导入sql的解决方案
  • 求个Excel导入sql的解决方案

  • :aspxer  Դ:csdn  :2007-6-12 3:44:39  ؼ:sql
  • /** 导出文本文件

    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"

    )

    --/* dBase IV文件

    select * from

    OPENROWSET("MICROSOFT.JET.OLEDB.4.0"

    ,"dBase IV;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]")

    --*/

    --/* FoxPro 数据库

    select * from openrowset("MSDASQL",

    Ҷƪл˵?
  • һƪ一个简单的数组+get方法问题,来者散分
    һƪ求救,几个小问题~~- -!初学者求助