odbc query

[Steve]

When running an odbc query it stops responding after so
long when I limit the parameters of the query, when I
don't limit it it retrieves the information but the file
is so big it won't fit in excel. Is there a buffer field
I got to change in my system to allow it to run after so
long?

 

[onedaywhen]

When running an odbc query it stops responding after so
long when I limit the parameters of the query, when I
don't limit it it retrieves the information but the file
is so big it won't fit in excel. Is there a buffer field
I got to change in my system to allow it to run after so
long?

I can't see a property in MS Query nor in the registry for Query or
ODBC.

Things to consider: do you need to change your SQL to work more
efficiently? Do you need to change your data e.g. denormalize a table?
Move data to a different data source e.g. from Excel to Jet? Can't
really advise unless you post some details.

--