Using Excel/DAO to execute mdb query on table linked to SQL... timeout?

[taigovinda]

Hi,

I've got some VBA code in Excel that runs a list of mdb queries to import data from SQL directly into Access and then process the data in Access. One of the mdb queries looks at a view in SQL. I made the view to look at this year's data and everything works fine - takes about 90 seconds to run this step. I changed the view to look at this year and last year's data and Excel just hangs up and never comes back when it tries to run the mdb query. When I open Access and run the mdb query, it works fine and takes about 3 minutes.

Any idea what might be the deal here? I'm kind of at a loss... I'm using Access 2003 and the mdb query is like this:

INSERT INTO Temp_Store_SQL_Non_Travel
SELECT [dbo_vSFP001_NonTravelCubeOCS tgs].*
FROM [dbo_vSFP001_NonTravelCubeOCS tgs];

Thanks for any help.

Tai

 

[taigovinda]

Any ideas here, why this (append) query works when run manually in Access but does not work when run in the MDB via Excel? Thanks.