https://support.microsoft.com/en-us/topic/why-is-my-add-in-crashing-1e02d873-04c8-4ecd-ac63-8f18507a3870
https://support.microsoft.com/en-us/office/excel-not-responding-hangs-freezes-or-stops-working-37e7d3c9-9e84-40bf-a805-4ca6853a1ff4?ui=en-us&rs=en-us&ad=us
https://social.msdn.microsoft.com/Forums/Lync/en-US/bff8e4f8-eb29-4454-8623-c1fffe195de7/why-does-excel-2013-crash-when-vba-creates-connection-to-access-2016-database?forum=accessdev
Eclipse Java error: This selection cannot be launched and there are no recent launches
How to fix the error:-
https://www.youtube.com/watch?v=m8EKjSSQRs0
final Code :-
Remove NULL from all the columns from SQL Table using Excel formula:-
1. use sp_help to get all the columns:-
sp_help SSAS_AC_DRILL
2. Paste SQL tables columns in excel
3. after that use following formula in excel to create SQL code
="update SSAS_AC_DRILL set "&A2&" ='' Where " &A2& " is null"
you will get following as formula output
update SSAS_AC_DRILL set LT ='' Where LT is null
4. copy and paste following in SSMS and execute:-
update SSAS_AC_DRILL set LT ='' Where LT is null
DELETE M
FROM MainTable M
LEFT OUTER JOIN SecTable S ON M.MainTableId = S.Idwhere S.Id IS NOT NULL