Results 1 to 2 of 2
  1. #1
    Hawkeyesv is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    11

    Linking from Excel assistance


    Hello all, I have an access database table that extracts its data from excel. The excel spreadsheet has my company’s logo as a picture in the first 3 rows. Is there a way I can structure my access data table/query so that it doesn’t try to read the rows with the logo in it (it isn’t null because of the photo…already tried creating a “if not null” rule)?
    What I do now is download the excel data sheet from my company portal and then delete the first 3 rows before generating my query/report on access.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    Can specify a range to import from.

    Review http://accessmvp.com/KDSnell/EXCEL_Import.htm#ImpSQL
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 7
    Last Post: 09-17-2020, 12:38 PM
  2. Linking MS Excel and MS Access
    By Lou_Reed in forum Access
    Replies: 2
    Last Post: 08-08-2017, 01:33 PM
  3. assistance with database to connect to excel frontend
    By stan101 in forum Database Design
    Replies: 1
    Last Post: 11-19-2016, 08:31 AM
  4. Linking Excel spreadsheet
    By nikogeorgiev in forum Import/Export Data
    Replies: 9
    Last Post: 05-16-2013, 08:24 AM
  5. Linking DB with Excel
    By Huddle in forum Import/Export Data
    Replies: 2
    Last Post: 09-09-2010, 07:40 AM

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