-
How to fetch data from database table and export to an excel sheet ?
I have tried this way to export data from a database table to store in an excel sheet, but it is only storing the last record of the received records. Can anyone help me.Set objDB = CreateObject("ADODB.Connection")objDB.ConnectionString = "DSN=mysql_qtp"objDB.OpenIf objDB.state=1 Then msgbox("Connection Is Establsihed") else msgbox("Connection is not opened") exittestEnd Ifsql_query = "select zipcode,...