I can do a select query but make table no go

[Rousseau10]

I do a select query to a linked external table, but when I turn into make table it takes forever. Also when I changed back to select but with a where clause it takes forever again.

If the records set I have selected in my query is large, is it not better to filter via where clause or performance worse becuase it has to take time to go through all the field in the where clause?

And last but far from least, how can I get the make table ot where clause to work without hangng access?

Basically all I need to do is export the linkied tables to excel




I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam

 

[PHV]

Why not export to excel a passthru query ?

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

 

[hneal98]

What does the query look like?