環境為windows2000 professional ,office XP ,sql server7 ,要實現excel 導入sql
中,語句如下:
Set CN = New ADODB.Connection
CN.Open "Provider=SQLOLEDB.1;password=6842;Persist Security Info=False;User ID=sa;Initial Catalog=hxf;Data Source=SERVER"
STR1 = "INSERT INTO BOM1 SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','EXCEL 10.0;HDR=YES;DATABASE= " & filename & "',sheet1$)"
CN.Execute STR1
MsgBox "BOM導入成功"
其中filename為文件名變量,執行至cn.execute str1時出錯:
執行階段錯誤'-2147217900(80040e14):
[ole/db provider returned message:找不到可安裝的ISAM.]
中,語句如下:
Set CN = New ADODB.Connection
CN.Open "Provider=SQLOLEDB.1;password=6842;Persist Security Info=False;User ID=sa;Initial Catalog=hxf;Data Source=SERVER"
STR1 = "INSERT INTO BOM1 SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','EXCEL 10.0;HDR=YES;DATABASE= " & filename & "',sheet1$)"
CN.Execute STR1
MsgBox "BOM導入成功"
其中filename為文件名變量,執行至cn.execute str1時出錯:
執行階段錯誤'-2147217900(80040e14):
[ole/db provider returned message:找不到可安裝的ISAM.]
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货