Solved

Records with Null Fields Don't Refresh

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

732 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