Link to home
Create AccountLog in
Avatar of ITsolutionWizard
ITsolutionWizardFlag for United States of America

asked on

ms sql excel

i have ms sql express server so I want to export sql script to export one table to ms excel to one of our shared folder in the network. And I will schedule to run daily at 8:00 am as well.
can you share with me the easiest way to handle it?
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ITsolutionWizard

ASKER

I do not have both items because it is sql express
1. SSIS Packages
2. SQL Server Agent Jobs
Sorry for the delay in response..
That's why I gave you the last option to use OPENROWSET with Windows Task Scheduler to meet your requirements..
Kindly let me know whether you got a chance to try that one out..