odbc query

  • Thread starter Thread starter Steve
  • Start date Start date
S

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?
 
Steve said:
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?
Click to expand...

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.

--
 
Back
Top