Excel Import Data from SQL- Date comes across as text
Posted on 2013-12-31
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.