62,041
社区成员
发帖
与我相关
我的任务
分享在asp.net中关于excel数据导入到SQL server例子
===============================================
请问如何将以下的关于EXCEL导入到ORACLE语句改成SQL SERVER :
===============================================
Dim strexcel As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFName & ";Extended Properties=Excel 8.0;"
Dim connxls As New OleDbConnection(strexcel)
Dim cmd As New OleDbCommand
Dim conn As New OleDbConnection
Dim cmdxls As New OleDbCommand
Dim MyTran As OleDbTransaction
Try
Dim ls_id As String
connxls.Open()
strSql = "select * from [sheet1$]"
cmdxls = New OleDbCommand(strSql, connxls)
rdxls = cmdxls.ExecuteReader
请问如何将以下的关于EXCEL导入到ORACLE语句改成SQL SERVER :
===============================================
Dim strexcel As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFName & ";Extended Properties=Excel 8.0;"
Dim connxls As New OleDbConnection(strexcel)
Dim cmd As New OleDbCommand
Dim conn As New OleDbConnection
Dim cmdxls As New OleDbCommand
Dim MyTran As OleDbTransaction
Try
Dim ls_id As String
connxls.Open()
strSql = "select * from [sheet1$]"
cmdxls = New OleDbCommand(strSql, connxls)
rdxls = cmdxls.ExecuteReader
...全文
请发表友善的回复…
发表回复
husiwei 2004-11-22
- 打赏
- 举报
up
孟子E章 2004-11-22
- 打赏
- 举报
执行sql 语句即可
sql = "SELECT * INTO tabName FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=" + Server.MapPath("xxx.xls") + "',[Sheet1$])"
sql = "SELECT * INTO tabName FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=" + Server.MapPath("xxx.xls") + "',[Sheet1$])"
ewen 2004-11-22
- 打赏
- 举报
哦，自已解决了。
jxzhang615 2004-11-22
- 打赏
- 举报
学习！！
