How to update the query result in excel ?

Question

0.00/5 (No votes)

See more:

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??

Posted 26-Jun-16 21:04pm

Member 12605284

Updated 26-Jun-16 21:29pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2016-06-26T21:29:00

Solution 1

Yes, it's possible:

SQL

SELECT IIF(ISNULL([yourField]), 0, [yourField]) AS SomeField
FROM [tableName];

For further information, please see:
MS Access: IsNull Function[^]
MS Access: iif Function[^]

Posted 26-Jun-16 21:29pm

Maciej Los

Comments

Member 12605284 27-Jun-16 3:55am

I want to update the result pasted in ms excel sheet. I think this code is for updating ms access sheet.

Maciej Los 27-Jun-16 4:01am

No, you don't. When you'd use above query, you'll see zeros instead of null values in Excel.

Member 12605284 27-Jun-16 4:07am

Can you tell me what should I put in [your field] section?? Thanks.

Member 12605284 27-Jun-16 5:01am

Got it. Thanks :)

Maciej Los 27-Jun-16 6:10am

I'm very glad. Can you accept my answer as a solution (green button) - formally to remove question from unanswered list?