Results 1 to 3 of 3

[Solved] Ignoring Blanks in Access

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2009
    Location
    London
    MS-Off Ver
    Excel 2003, 2007
    Posts
    80

    [Solved] Ignoring Blanks in Access

    Hi Everyone,

    I created an append query in Access 2007 to gather the data from my source (an excel sheet) however it is copying the blank spaces. Does anyone know how can i tell access not append anything if the source is empty?

    Would really appreciate your help.

    Thanks in Advance.
    Last edited by crazysniper; 08-21-2010 at 07:34 PM.

Thread Information

Users Browsing this Thread

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

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