Hi,
I could not find any method but as Excel is an COM server, we can add it in references and create an instance of Excel. Then u can save ur data to excel sheet. your code could be like this.....
Dim Rs As Recorset
Dim oxl As Excel.Application
Dim owb As Excel.Workbook
Dim osh As Excel.Worksheet
Dim FileName as String
Set oxl = CreateObject("excel.application"
Set owb = oxl.Workbooks.Add
Set osh = owb.ActiveSheet
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.