I need an old-ASP solution to open an populate multiple excel worksheets with data from a recordset retrieved from a stored procedure. The "HTML-Tables" methodology wont work as it only allows for populating a single worksheet. I am also restricted from using an XML solution. I have heard that this can be done using ADO...
I have seen syntax examples (below) but have yet to get one to function properly.
strSQL = "INSERT INTO [worksheet$] IN '" & strPath & "workbook.xls' 'Excel 2003;' SELECT * FROM tablename"
strSQL = "SELECT * INTO [Excel 2003;Database=" & strPath & "workbook.xls].[worksheet$] FROM tablename"
My thanks in advance to anyone who can offer assistance.