How to fetch data and display in Excel using Macro(VBA)
-
Hi all, I can able to fetch a single data from Sql and display it in the Excel sheet using Macro, this is the code. I am getting in the Text Box: sno = TextBox1.Text When i am clicking the Ok button: Query = "Select sname,scity from smaster where snum='" & sno & "'" Set QueryRs = oConn.Execute(Query) Sheet1.Cells(1, 1) = QueryRs("sname") Sheet.Cells(1, 2) = QueryRs("scity") Result: Name, city displayed in the Excel sheet1 Now my problem is how to fetch multiple data and display (like how to use loop in it) waiting for timely help
Tech_spidy
-
Hi all, I can able to fetch a single data from Sql and display it in the Excel sheet using Macro, this is the code. I am getting in the Text Box: sno = TextBox1.Text When i am clicking the Ok button: Query = "Select sname,scity from smaster where snum='" & sno & "'" Set QueryRs = oConn.Execute(Query) Sheet1.Cells(1, 1) = QueryRs("sname") Sheet.Cells(1, 2) = QueryRs("scity") Result: Name, city displayed in the Excel sheet1 Now my problem is how to fetch multiple data and display (like how to use loop in it) waiting for timely help
Tech_spidy