Importing web data to Excel 2003

J

JohnB

I have built a flight planning program for aviation using Excel 2003. I am
trying to find a function to import winds aloft from NavCanada's aviation
weather site, to avoid manual entries. Is there a web site where raw text
data from NavCanada's site to import, or a way to import it from their normal
web display?

Below there is a link to NavCanada's normal display of data.

http://www.flightplanning.navcanada.ca/cgi-bin/Fore-obs/fd.cgi

Any help would be appreciated.

thanks
 
G

Gord Dibben

I get an access denied on your URL................no permission.

But have you tried Data>Import External Data>New Web Query?

Enter a valid URL then click on the yellow arrows to select the data for
import to Excel.


Gord Dibben MS Excel MVP
 

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

importing data into excel2003 from some web site? 1
Importing data from Excel worksheet into Excel template 2
Importing data from an application to an Excel worksheet 1
How to avoid date convertions when importing external web data? 1
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
importing/linking data from an Access 2003 Query to an Excel 2003 2
Data types when importing Excel data to SQLServer 1
Import external data - web query 3

Top