SQL Server temporary tables not persistent when created with cursor parameters #377 Open GoogleCodeExporter opened on Mar 18, 2015 ...

Using SQL statements in Excel enables you to connect to an external data source, parse field or table contents and import data – all without having to input the data manually.

What steps will reproduce the problem? The following SQL statements are all run within the same database connection and cursor: sql = r"SELECT X, Y, Z INTO #temp_table1 FROM mytable WHERE A = ?" ...