Changing External Data Location Link in MSQuery
I find it easier to use the Import Data command from the Import External Data
submenu. This allows you to bypass MS Query, and define your own
connection/sql text, in the last step you can output to a table or pivot
table. Having set it up, you can just choose Edit Query from the same menu to
easily update the connection parameters.
|