MS Query - Problems Obtaining Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Which version of excel are you using? All versions except 2007 have a
limit of 65536 rows and cannot present your data that exceeds 100000
rows
 
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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
Another issue could be if you are using non-english characters in Ent.
manager. If so, when you paste to MSQuery, international characters
are not pasting correctly.

www.exciter.gr
Custom Excel Applications!
 
Back
Top