Hi, how can I simply read the excel data using vb 6.0?
Jump to Post
Use ADO to connect to the excel file using MDAC (Microsofts Data Access components)
'Read Excel File Using ADO Public Function Read_Excel _ (ByVal sFile _ As String) As ADODB.Recordset On Error GoTo fix_err Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim sconn As String rs.CursorLocation = …
All 3 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.