Search the Community

Hi Guys, I have to some scheduling export to excel like pull every week or daily. i found there is one solution for this is using MS SQL Server Agent. I guest i able to save the query. But the problem is the query result save in SERVER instead of the shared drive. Anyone have face this problem before? or maybe you have a better solution for that? The C:/ drive actually is from server side.

How to import data from webpage (from ajax) Dear Members, I would like to import data from the following webpage with ajax on that page to excel. I am not the developer the following website, I am just an user and want to import data from web to excel. http://www.dukascopy.com/traderconte...n=liveForecast When I want to download data from page 2, the website does not generate a new web address, so I am facing a problem with inserting a link to web address for page 2,3 and likewise. But one great guy from other forum have already given the solution by giving the following links for different pages of ajax. page1: h**p://www.dukascopy.com/tradercontest/?instrument=USD%2FCHF&side=&state=&trader=&page=1&sort_by=&sort_dir=ASC&action=forecastGrid&ajax=1[/url] http://www.dukascopy.com/traderconte...astGrid&ajax=1 Page2: h**p://www.dukascopy.com/tradercontest/?instrument=USD%2FCHF&side=&state=&trader=&page=2&sort_by=&sort_dir=ASC&action=forecastGrid&ajax=1 http://www.dukascopy.com/traderconte...astGrid&ajax=1 That is just by changing the page no to 1,2,3 and likewise. I have kept the entire web address above to show where to change the page number. But when I see the webpage with the links given above for particular pages, the background color of the data, as can be seen from the original link (first link above), does not appear on the web page and in turn not in excel as well. Would you please look at the above and let me know how to get the background color as well in the excel. Thank you very much for all your help. With kind regards, Excelllearner2012