1,508 questions
Daily Report Automation
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 33%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DM
546
Reputation points
Have a table which needs to be converted to Excel and emailed everyday. We don't have SSIS or SSRS installed. Is there an other way inside SQL Server or Windows or some third party tool that I can use to automate it. Thank you for your efforts.
Developer technologies Visual Basic for Applications
{count} votes
-
Dillon Silzer 57,826 Reputation points Volunteer Moderator2022-10-09T03:20:52.617+00:00 Where is the SQL Server running? Can it be queried through the internet or only locally?
Have you tried using any of the Power Apps / Power Automate platform?
-
DM 546 Reputation points
2022-10-09T17:48:56.877+00:00 Hi DillonJS,
SQL Server is running locally. We haven't tried Power Automate; suggestion requested.
-
DM 546 Reputation points
2022-10-13T18:33:55.547+00:00 Hi,
Awaiting reply. Is there any other option apart from Power apps/Power Automate. Thank you.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tom van Stiphout 1,861 Reputation points MVP Volunteer Moderator2022-10-14T03:44:07.773+00:00 Several clients have a workstation with Microsoft Access installed, and it can connect to SQL Server, format a report, and send it out.
Sign in to comment
Sign in to answer