How can I insert data fra an array into Excel by using only one database connection? I have an array named dimen(20), how can I insert the values of this in Excel?
I know how to execute sql commands e.g:
Code:Protected Sub medieDimension() Dim strCn As String = "Provider=Microsoft.jet.oledb.4.0;" strCn += "Data Source=" & Server.MapPath("priser04.MDB") & ";" Dim strSql As String = "Select * FROM medieDim WHERE matId=1" Dim strResultsHolder As Integer = 0 Dim objConnection As New OleDbConnection(strCn) Dim objCommand As New OleDbCommand(strSql, objConnection) Dim objDataReader As OleDbDataReader objConnection.Open() objDataReader = objCommand.ExecuteReader() For i = 0 To objDataReader.FieldCount Do While objDataReader.Read() = True medieDim(i) = objDataReader("dimension") i += 1 Loop Next objDataReader.Close() objConnection.Close() End Sub




Reply With Quote