Posted on 2004-08-03
In access, I have a front end form, listing query names (some parameter queries), user makes a selection, selects output format and I use DoCmd.OutputTo to dump the query to the selected output
These queries are essentially a dump of data acting as simple reports.
Now that I have upgraded to using SQL server, I have made these queries into stored procedures, some taking parameters.
Question is, I dont think I can use DoCmd.OutputTo, due to the parameters in the stored procedures, does anyone know of a equivalent? I was looking for a quick way to run a query, passing in parameters and dump to a selected output.
Or is this a case of having to create a ADO recordset, read thru records and dump contents into a file.