Question:
Can anyone tell me how to extract data from a website into Excel and have it update itself daily?
dynamite
2007-08-22 14:45:14 UTC
The problem is that I need to only take certain information from the table on the website and that the website only lists 25 items at a time and then i have to view the next 25 to get more and so on. There's probably about 500 items altogether. I've been just cutting and pasting on a weekly basis, but it is very tedious and doesn't give me the daily results that I'm looking for. Does anybody have a better way. Thanks.
Three answers:
Einstein
2007-08-23 02:41:00 UTC
Use a VBA macro to do the updating.



Macros demystified: What they are and why to use them - Help and How ...



http://office.microsoft.com/en-us/help/HA100072101033.aspx



________________________________________



Word 2003 uses a Web service to query the database for data to populate worksheets.



This Web service includes four public functions:



Verify. Used by Word to verify whether the Web service is functioning correctly.

A function that extracts all fields from the database.

A function that extracts data based upon a WHERE clause.

Other extraction functions.

For information and examples as how to perform the Web data extraction:



http://msdn2.microsoft.com/en-us/library/aa701256(office.11).aspx#Office2003Integratingwithaspnet20_CreatingaWebServicetoExtractSalesData

__________________________



An Overview of Key New Visual Studio 2005 Features

... much like you would lay out Web Form controls in an HTML table ... open in the visual designer, with merged Excel menus. Data ... This makes it very easy to integrate data from a Web service ...



http://msdn2.microsoft.com/en-us/library/ms364072(VS.80).aspx

__________________________________



SQL Server solution:



Data Integration Solutions for Master Data Management

... data from Microsoft Excel, and third party demographic data via Web ... of cleansed, standardized data such as a reference table ... are embedded in a text data source. For example, you could extract ...



http://msdn2.microsoft.com/en-us/library/Aa964123.aspx



_________________
AQuestionMark
2007-08-23 17:34:12 UTC
If you don't mind posting the site link that has the table, sure i can work something out, cause every site is build differently even look similar.



If you mind then you can buy a data mining software call Monarch, with a butterfly logo, the latest version can sort out data from a web page and export it to an MS excel file.



Monarch's spec.

http://monarch.datawatch.com/monarch-standard-specs.asp

Price is US$240up on ebay buy it now
ola
2016-05-20 06:09:06 UTC
As the first person said - you cannot without permission from the webmaster and knowledge of sql But if you click and drag to hightlight data - you can copy web info and paste into excel spreadsheet


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...