VBScript to run SQL Server stored procedure and output to file?

[aiko27]

Hi All

Can you please let me know how a VBSCript can connect to a SQL Server, run a pre-defined stored procedure (a simple select that returns a table results), then output the table into a file and save it at a location?

Many thanks!