+ Reply to Thread
Results 1 to 2 of 2

Access indicating values/data in seemingly blank cells in Excel files when importing?

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    USA
    MS-Off Ver
    2010
    Posts
    40

    Question Access indicating values/data in seemingly blank cells in Excel files when importing?

    When I import Excel files into Access, Access indicates that there is data (outside of the header row) in each cell even though the cells appear to be blank.

    Any idea what would cause this type of issue?

    Update: I've done a little more research since posting this question and now I'm wondering if it's because these cells have Null values as opposed to Blank values. From what I understand, these are two different things, but I can't seem to find any info on how to tell if a cell has Null value instead of Blank. Does anyone know?
    Last edited by AKM1; 05-05-2014 at 02:03 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,943

    Re: Access indicating values/data in seemingly blank cells in Excel files when importing?

    At I guess, I would say that a "blank" cell has nothing in it. No data, nor formula, just an empty cell. Whereas, a "null" value might be as as result of a formula, for example,
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or maybe it has a space in it?


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-13-2013, 03:25 AM
  2. Importing data into Excel from Access
    By Blondegirl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2006, 05:51 PM
  3. Importing data from Access to Excel, but I need to vary the table from Access
    By Liz L. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2006, 09:15 PM
  4. Importing EXCEL file into access
    By schleppy2 in forum Excel General
    Replies: 1
    Last Post: 03-13-2006, 05:25 PM
  5. importing data from access-database access file
    By amrezzat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2005, 04:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1