Question about .VBS script creation to export DB to excel format and paginate excel max records
Posted on 2008-10-21
This one may be a bit complicated. I have a stored procedure we will call sp_report on a SQL server (2000 enterprise/clustered). I am looking to for a .VBS script (for automation purposes) that can execute that stored procedure and automatically export the results to an excel file. Also there are greater than 80,000 rows of results on the sql db, so I would need the script to make a new workbook for every 65000 or so records generated via the output of the stored procedure and continue exporting the results to that new workbook (in the same file) and perhaps continue doing this until all results have been exported and the procedure has completed its course.
Thank you for your help in advance.