Question: how to import data from excel to sql server temp table?
Answer: Always set date format. SET DATEFORMAT dmy; ...  Always wrap your script in a transaction. ...  Use #temp tables to import data from excel. ...  Save Excel as a tab-delimited-values file. ...  Convert columns into CSV list. ...  Create insert SQL statements from columns.