Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Records with Null Fields Don't Refresh

Posted on 2014-04-02
1
288 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 500 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

791 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