MS Query - Problems Obtaining Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gtgtgt - 26 Oct 2007 20:07 GMT

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

Reply to this Message

www.exciter.gr - 27 Oct 2007 20:18 GMT

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

> Hi thanks for any advice you can offer.
>
[quoted text clipped - 8 lines]
> Thanks,
> gt

Reply to this Message

Nick Hodge - 28 Oct 2007 09:16 GMT

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog

> 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
[quoted text clipped - 15 lines]
>> Thanks,
>> gt

Reply to this Message

www.exciter.gr: Custom Excel Applications! - 29 Oct 2007 23:44 GMT

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!

> Exciter
>
[quoted text clipped - 32 lines]
>
> - Show quoted text -

Reply to this Message