Most of my programming experience has been with MS Access 2000 with a split FE/BE, but now we are slowly migrating to MS SQL Server, and I am a fish out of water. I suspect this is a very simple problem.
I use the following code in my MS Access application.
strSQLtext = "INSERT INTO TempEbayOutput1 SELECT qryEbayUploadOnlyPhotos2.* FROM qryEbayUploadOnlyPhotos2; "
When processing 11,000 records, the code below takes 15 minutes to run. All tables are now stored on the SQL Server. I'm not sure how to take advantage of SQL to optimize speed. Would like to get advice whether this should be a stored procedure or a pass thru query, and help creating such.
Note that the query, qryEbayUploadOnlyPhotos2 must be create by my code on the fly.