How to import external data into excel?

B

Bill Sharpe

Eric said:
When I import following link into excel, because the web page is too long,
the imported data is missing short_selling section, because of the limitation
on the number of row for Excel 2003.

http://www.hkex.com.hk/markdata/quot/d091102e.htm#short_selling

Does anyone have any suggestions on import a selected section of web page
into excel?
Thanks in advance for any suggestions
Eric
Click to expand...

Excel 2007 has 1,000,000 rows. You might also try highlighting the rows
you are interested in on the website(assuming you don't need all of
them), copying to the clipboard, then pasting into Excel.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to load specific range of data from html into excel? 3
How to change the date format from import link? 1
How to insert web page content into excel worksheet? 1
How to load web page into Excel properly? 2
Add additional information to excel form after original data entry 0
How to Import Formatted text as new Slides in PowerPoint 0
Where is the Data Import Excel button in Excel 2007 6
How to modify the web link for retrieving data from external sourc 12

Top