MS Query - Problems Obtaining Data

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
 
W

www.exciter.gr

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
 
N

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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
W

www.exciter.gr: Custom Excel Applications!

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top