G
Guest
Hi. I am looking to generate an spread sheet based off of a dynamic query.
The report is for amount overrides in a small internal system connected to
SQL Server. I have a form in Access that gives the user options to select
the information they want from a series of dates, user names, and amounts.
What I am looking for, is after I have that information, I need to open a NEW
Excel file and put in all the information they requested. I use an
ADODB.Recordset for the query (i.e. rst = new adodb.recordset then rst.open
"SQL QUERY GENERATED"). I need to output the rst somehow. Please let me
know if you have any ideas. I have never tried to export, so it may be
something as simple as a function I don't know about. Thanks.
The report is for amount overrides in a small internal system connected to
SQL Server. I have a form in Access that gives the user options to select
the information they want from a series of dates, user names, and amounts.
What I am looking for, is after I have that information, I need to open a NEW
Excel file and put in all the information they requested. I use an
ADODB.Recordset for the query (i.e. rst = new adodb.recordset then rst.open
"SQL QUERY GENERATED"). I need to output the rst somehow. Please let me
know if you have any ideas. I have never tried to export, so it may be
something as simple as a function I don't know about. Thanks.