Results 1 to 2 of 2
  1. #1
    coolkat99 is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Aug 2018
    Posts
    1

    Import Excel file

    Hi

    I am new to Access. I want to import 2 excel files and then compare them in Access. However, some of the cells in the excel file are empty, which is expected (the data in the excel files is from a business objects report) When I import the data to Access, I want to ensure that when the 2 excel files are compared Access recognises these empty cells and matches them up - (they should match, empty cell in file 1 v empty cell in file 2 should be a match) but Access does not seem to want to show these as matches. How can I get Access to work the way I want it to?

    Many thanks



    Will

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You cannot match nothing via a join.
    you can ask for nulls,
    Tbl1.[field1] is null and tbl2.field1 is null.

    produce fields TRUE if null THEN the query can join the TRUE.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 34
    Last Post: 08-09-2017, 09:57 AM
  2. Replies: 2
    Last Post: 02-28-2017, 01:34 AM
  3. Import Excel file into a table
    By lucky33 in forum Import/Export Data
    Replies: 2
    Last Post: 09-03-2014, 01:17 PM
  4. Import access query data into excel file, using excel vba
    By exceljockey in forum Import/Export Data
    Replies: 3
    Last Post: 11-15-2013, 02:36 PM
  5. Import Excel file based on a date and time in file name
    By nhylan in forum Import/Export Data
    Replies: 4
    Last Post: 04-16-2013, 03:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums