Query output in Excel

[Anna]

I am trying to import a database data in excel from db_vista database
and it limits the output to 25 rows. Does anybody know how to increase
the output?

 

[Ron Coderre]

Anna

Just a guess....try this:

Edit the query in MS Query
<edit><options>

Is "Limit number of records returned to" checked?

Does that help?

Regards,
Ro

 

[Anna]

It does not help.
I set it to 100, and it still just bring 25 records. I am using ITTIA
ODBC to import the databse in excel. Can ITTIA ne the problem?

 

[Ron Coderre]

If you could post the essential SQL for the query we'd have a better
idea of what you're dealing with.

Regards,
Ron

 

[CLR]

I have a similar problem in another Database and it's because of a
"permissions" setting in the Database Program.....

Vaya con Dios,
Chuck, CABGx3

 

[kylv]

Hey Anna,

It sounds like you're using an evaluation copy of ITTIA ODBC which
limits the number of records that you can access.

What you need is the full version of ITTIA ODBC available from ITTIA
(http://www.ittia.com).

-Steven

 

[dbahooker]

a) excel is crap
b) excel users are idiots
c) keep your data in a database
d) learn how to use them
e) replace 3rd party tools with custom database applications; and you
won't be stuck buying 3rd party odbc drivers
f) various tools like crystal and or access and or sql server are
ASTRONOMICALLY more powerful than excel.
g) lose the training wheels and grow some balls