<div>
Is it stored as a date type on your database? What is the format it's coming back ?
</div>


<div>
I'm suspecting it's something like &quot;yyyy-mm-dd&quot;? In which case you'll need to parse the date as a string in your sql to the following format &quot;mm/dd/yyyy&quot; That should be enough for excel to recognize it as a date
</div>


<div>
you can separate the string into 3 columns and rebuild the date depending on the date format <br />
like mid(e1,0,2) as month and mid(e2,4,2) as day and mid(e2,7,4) as year and then rebuild the date in excel sheet <br />
<br />
it will help and it isvery good to solve this issue
</div>


<div>
as rob jurd suggested, please advise the column format in SQL server table.<br />
<br />
But for me, I ALWAYS format dates as yyyy-mmm-dd &nbsp;as it is unambiguous. <br />
<br />
For me in Oz, the std display format is dd/mm/yyyy, but that doesn't import correctly. &nbsp;So if i use dd/mmm/yyyy, the display is ok, and all conversions and imports work fine too.
</div>


<div>
Thanks to all contributions
</div>


<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
I'm importing data from an MS SQL database into an Excel sheet using data connection. The SQL table includes a Date column, but this column comes to Excel as text rather than date.<br />
<br />
Is there any way I can fix this issue?<br />
<br />
The good news is..I can loop through each and every cell in that particular column using VBA code, so perhaps this could help coming up with a solution.<br />
<br />
Thank you,<br />
Hani
</div>
</div>


Hello experts,

I'm importing data from an MS SQL database into an Excel sheet using data connection. The SQL table includes a Date column, but this column comes to Excel as text rather than date.

Is there any way I can fix this issue?

The good news is..I can loop through each and every cell in that particular column using VBA code, so perhaps this could help coming up with a solution.

Thank you,
Hani

Excel Import Data from SQL- Date comes across as text

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,