Loading

Not able to Import the date column from Excel to SQL 2012

SANJAY KUMAR

Dear sir/Madam,

can you please help to share the code to import the date & time column from Excel to SQL 2012. Where Im unable to import only the date & time column from excel 2013 to SQL 2012 using ASP.NET. SO please kindly requesting you to share the code.

BR,

sanjay JP

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sai Kumar Koona8y ago
SQL server is probably not getting the full DateTime format correctly. Can u import it first to DataTable and then to SQL Server by formatting that DateTime column to DATE?