Avatar of Mehawitchi

asked on 

Excel Import Data from SQL- Date comes across as text

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,
Microsoft ExcelVisual Basic.NET

Avatar of undefined
Last Comment

8/22/2022 - Mon