troubleshooting Question

Refresh Data In excel

Avatar of svs1919
svs1919 asked on
Microsoft OfficeMicrosoft SQL ServerMicrosoft Excel
5 Comments1 Solution23 ViewsLast Modified:
Hello experts,

I have an excel file which is connected to data source use an ODBC driver. I can open the excel and refresh the data withought any issues. However I want to automate the process to refresh the excel the data. I tried macros and it worked fine when I run it manually but when I call it from a SQL Agent job the refresh fails as the excel file has to open then refresh and then close with updated records and this might not be happening when running from a job.

How can I now refresh my excel file on a schedule?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros