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.