MS Query - Problems Obtaining Data

[gtgtgt]

Hi thanks for any advice you can offer.

Attempting to build a pivot table using external data, connecting to a
Microsoft SQL Server. I paste the SQL that I use in Enterprise Mgr directly
into MS Query. When I execute the query, the dataset is displayed in MS Query
- all 107,000 records. When I ask MS Query to return the data to Excel, I get
this message: "Problems Obtaining Data."

Help.

Thanks,
gt

 

[Nick Hodge]

Exciter

This is external data so the 65536 rows for the datasource does not apply.
There is of course a limit for unique items in the table, but I doubt this
is the issue

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog