I have a
#tempTable that was created using
SELECT * INTO #tempTable FROM OPENROWSET('Microsoft.Ace.OLEDB.12.0', 'Excel 8.0;Database=MyFileName.xls', 'SELECT * FROM [Sheet1$]')
Is there an easy way to copy the table structure of the
#tempTable to a new physical table?
The temp table contains a lot of columns which contain numbers, dates, decimals, and strings, and I do not want to have to identify and manually define every column.
I am using SQL Server 2005