?
Solved

Records with Null Fields Don't Refresh

Posted on 2014-04-02
1
Medium Priority
?
309 Views
Last Modified: 2014-04-18
I have inherited a bunch of Excel spreadsheets that pull in data from Access databases using "Connections." I am eliminating them one by one, as I do not like this method for a number of reasons. But I have encountered something weird.

When the source of the connection has a null value in one of the refresh field, the record doesn't come into Excel. If I copy the source query out of the "Connection/Properties" box, clean out the apostrophes and put brackets around table or field reference with spaces in it and then run the query, the records with nulls show up. But when I run the refresh inside Excel, they don't.

Has anyone encountered this before. I have now found it in three different situations, and if this is a flaw in the Connection/Refresh method I've got a bunch of people who may be getting faulty data - at least until I can change the way their workbooks get populated.

Thanks.
0
Comment
Question by:Buck_Beasom
1 Comment
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 2000 total points
ID: 39989630
I just tried this and mine works OK (O 2010).
I deleted the contents of a text field in the table (implying NULL) and refreshed and it worked OK.
Is the problem not related to un-bracketed table or filed names?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question