Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I can do a select query but make table no go

Status
Not open for further replies.

Rousseau10

Programmer
Feb 22, 2005
242
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top