Date Converting To Number On Import From Excel To Sql Server

I am trying to import a table from Excel into SQL Server and there is one field that sometimes contains a date (mm/dd/yyyy) and sometimes contains a date and text (mm/dd/yyyy notes

Solution 1:

You could try this:

1. First export the excel file as Text with Tab delimiter using Save As:

   

2. Then open up SQL Server and in the import wizard, pick Flat File (that is the name SQL uses for raw text files, CSVs, etc):

   

After that, just make sure that you have the right things set:

I highlighted the parts that are usually important during the import.