求个Excel导入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",