I have imported some data from MS access to MS excel through SQL query in VBA. Now I want to update that data(In excel) by replacing empty cells with "0". Is there any way to do that using the same query??
What I have tried:
I have tried this using vba code. it works. But is there any way to do it in the same query??