Results 1 to 2 of 2
  1. #1
    daniboi is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2017
    Posts
    8

    Importing/Linked Excel Data into Access

    Hi All,



    In the interest of avoiding tremendous data entry of new data every day, i want to link my daily raw data so it gets updated automatically which i am able to. However the challenge i am facing is this:

    For example:

    Col A-D are linked and updated automatically daily in excel, but Col E-H i want to be able to input data manually and i cant because its a linked excel file and it wont let me edit.

    Is there anyway to achieve this?

    I wont mind importing and rewriting Col A-D on a daily basis in my database ONLY IF it OVERWRITES/UPDATES everything in JUST THOSE COLUMNS so as to NOT skew up the corresponding manually entered columns...

    Please advise.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you CAN use a linked excel file, but access cannot be open while you do it.
    another way, instead of the master file, youd link to a copy of the master:
    the access would link to c:\folder\ImportCopy.xls

    steps:
    edit and save the master excel file,
    click a button to run macro to SAVE AS to the linked copy.
    run access import.

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

Similar Threads

  1. importing excel data to access via VBA
    By mazemi in forum Programming
    Replies: 4
    Last Post: 11-22-2016, 12:27 PM
  2. Importing excel into access data model
    By aisling21 in forum Access
    Replies: 2
    Last Post: 05-12-2015, 07:03 AM
  3. Importing Excel Data Tables into Access
    By Itch in forum Programming
    Replies: 5
    Last Post: 09-08-2012, 11:27 AM
  4. Importing Data from Excel to Access
    By dkatorza in forum Import/Export Data
    Replies: 3
    Last Post: 11-05-2011, 09:17 AM
  5. iMPORTING DATA FROM EXCEL TO ACCESS
    By Rameez in forum Import/Export Data
    Replies: 7
    Last Post: 06-16-2009, 12:05 PM

Tags for this Thread

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