Solved

Records with Null Fields Don't Refresh

Posted on 2014-04-02
1
294 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
[X]
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
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

696 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