(SQL) CREATE PROCEDURE sp_Test AS SET NOCOUNT ON SELECT output_file.* INTO #tblNewTables FROM output_file WHERE output_file.Phys_Num = '000303' -- Part II SELECT * FROM #tblNewNamesand then call your sp in your code like:
set cmd.ActiveConnection = (Your connection obj) cmd.CommandType = adStoredProc cmd.CommandText = "sp_Test" set rs = cmd.ExecuteHope this will help (and work...).