Results 1 to 4 of 4
  1. #1
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43

    Have linked Excel files to Access 2010 how to create local table and export back into same Excel Doc


    I need some assistance. I have several linked tables from Excel for querying purposes in an Access web database. How can I create a local copy of these table to create forms that I can update/add new data then export back into the same Excel file. I have tried the make table query as well as copy/paste method and nothing seems to work. I am not familiar with VBA either.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if they are attached, then run a maketable query.
    change the data
    when done you must delete to old excel file, killfile filename
    then
    export using docmd.transferspreadsheet.

    if you do NOT delete the old file, it could mix up the old data with the new data.

  3. #3
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43
    Quote Originally Posted by ranman256 View Post
    if they are attached, then run a maketable query.
    change the data
    when done you must delete to old excel file, killfile filename
    then
    export using docmd.transferspreadsheet.

    if you do NOT delete the old file, it could mix up the old data with the new data.
    Thanks Ranman. Can you breakdown and clarify how to delet old excel file, killfile filename? and how to export using docmd.transferspreadsheet.

    Sorry I am very new to Access but am willing to absorb and learn from all you experts in this forum.

  4. #4
    RAshA.pro777 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    41
    Aha, I understand that you import data from excel sheet then updating it Then know you should to make a button on the same form in that button command you can write amacro to save the updated data in excel files


    Sent from my iPhone using Tapatalk

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

Similar Threads

  1. Replies: 6
    Last Post: 02-16-2016, 09:20 PM
  2. Replies: 1
    Last Post: 10-16-2014, 10:36 PM
  3. Replies: 7
    Last Post: 04-25-2013, 03:47 PM
  4. Excel files on sharepoint linked to access
    By Bertrand82 in forum Access
    Replies: 3
    Last Post: 01-31-2013, 11:57 PM
  5. Export to Excel from Pivot Table in Access 2010
    By nicon2k in forum Import/Export Data
    Replies: 0
    Last Post: 04-10-2012, 07:02 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