Categories
Development

Is there a way to format date from excel recordset

I get data from SQL Server and now I want to copy it in Excel worksheet. I try to format “start_date” but it apply format only on the first column, all other display as stored in SQL Server. Could you please suggest code modifying? Sub ReadMBDataFromSQL() Dim Server_Name, Database_Name, User_ID, Password, SQLStr As String Set […]