In addition to file paths on the computer, you can also specify remote URLs: Web (HTTP) and FTP (File Transfer Protocol) URLs to import the XML from.
HTTP (Web) URLs
Specify a HTTP URL by copying it from the Web Browser, for example.
http://www.weather.gov/data/current_obs/KBUR.xml
If access to the file requires a user name and password, you can specify it in the following format. Please note that this works only when using HTTP based authentication (Basic or Digest). It does NOT work with HTTP Form-based authentication (where you enter the user name and password into a Web form to gain access).
http://user@password:www.example.com/path/to/file.xml
FTP URLs
In addition to HTTP URLs (used in web browsing), you can also add FTP URLs from which the XML is to be imported.
Type an FTP URL as follows. Note that this example uses anonymous FTP to fetch the XML file.
ftp://ftp.example.com/path/to/file.xml
Need to use a user name and password to retrieve the file? Specify the URL in the following format.
ftp://user@password:ftp.example.com/path/to/file.xml
If the FTP server needs a port to be specified, use the following format:
ftp://user@password:ftp.example.com:port/path/to/file.xml
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.