web data mining

Hi All, I'm working as analyst and I have been using web queries in Excel as a way to automatically get stats into my spreadsheets which are formatted for further analysis. Previously i was getting data from a different website which is no more operational. Now I have to import data through...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Hello people :) I need to get data from web, the website is formated as text, it has few numbers, but every day address changes (e.g. www.site.com/1; www.site.com/2...) So how can i make a function to check number in my field in Excel (e.g. A1) and then retrieve data from www.site.com/1 and...

I have 300+ locations going into PowerMap. About 1/3 fail. I will have to use GPS coordinates instead of Street Addresses because many of the failures are for rural addresses BingMaps just cannot resolve correctly. There are enough locations with shared Zip codes to make map by Zip code an...

Ok, this is what I would like to do. I need to access an aspx website that I log into with my own personal login. There is a specific collection data I would like to then navigate to and that is a web form that houses data for my clients. I want to aggregate this form data into an excel sheet. I...

I have been using excel web query to extract data from web pages whenever I needed. Based on which I can perform many opetations even auto refreshing data at an interval of 5second. But this time when I am trying to fetch data from cisco CUIC reporting website deployed by my company with output...