I have an Excel file that gets it's data from the SQL Server table (actually, view).

In the SQL Server table, I have a Date field (YYYY-MM-DD), with a proper Date datatype. 

However, when this data is loaded into Excel, Excel does not recognize this field as a date and thinks it is a string.

How can I import this field that Excel recognizes it as a date?

Thanks!

You could do the following:

• Select the column with the dates-as-strings.
• Make sure that the number format is set to a date format.
• On the Data tab of the ribbon, click Text to Columns.
• Click Finish without changing any settings.