|Subject:||Excel 2007 - connect range to external data source|
|Date:||Tue, 8 Jul 2008|
When I use query to connect to an external ODBC data source a table is
automatically created. I really don't want a table, I just want a data range
that can be refreshed. If I convert the table to a data range, the
query/connection information is deleted. How can I connect a data range to
the ODBC source?