query from ODBC linked table crashes when converting to Excel

[romanzero]

Hi,

I have a query with five tables -- all of them non-updatable linked ODBC.

The results of my query are about 1900 rows and 42 columns. Everything is great except...

When I try to dump the query into Excel the whole DB crashes.

I have tried to limit the results and do a piecemeal transfer into Excel but I still crash.

Any ideas? Does it have to do with the ODBC?

Any help would be appreciated!

 

[PHV]

When I try to dump the query into Excel the whole DB crashes.
How are you doing the dump ?
Any error message ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[romanzero]

PHV,

It just stops.

No error...just "application not responding" from the Windows Task Manager.

I usually use the built-in Tools>Office_Links to dump into Excel. However, when I first tried to find work arounds I tried a selct all records - copy - paste. That too caused the DB to crash.

???

 

[PHV]

If compacting/repairing the database does not solve the problem you may try converting the query to a make table query and then dump the newly created table to excel.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[romanzero]

I took the make table route. It works! Thanks.

Any idea why the query was crashing the DB? Was it too big?