To connect to an SQL Server database running on host name (or ip address) host:
host@
To connect to a named database (or catalog), specify the database name as follows:
host@databaseName
If you are running multiple instances of SQL Server on a given host and you would like to connect to a named instance:
host\instanceName@databaseName
Use the following syntax to specify the the current computer as the server:
localhost@
Or alternatively, the empty string “”.
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.