Hi, how can I simply read the excel data using vb 6.0?
wil66
0
Newbie Poster
Recommended Answers
Jump to PostUse 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 …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.