Results 1 to 3 of 3
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Looking to link Access and Excel

    In the following tutorial shown here:http://www.functionx.com/access/Lesson05.htm,
    it talks about importing data from MS Access 2010 and Excel 2010. This is one way
    to interface Access and Excel.

    However, I am at the moment more interested in linking table from MS Access 2010
    to Excel 2010 spreadsheets, and vice versa.

    Thus a change in an Access table would be reflected in a linked Excel spreadsheet and vice
    versa.

    I have not found a good tutorial online that explains that. That is my request, to find the
    tutorial online or in a book (preferably online).

    Any suggestions for a website or book would be greatly appreciated.

    Thanks in advance.

    Respectfully,

    Lou_Reed

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    I can't speak for updating MS Access data through Excel because I have never done it (but I'm almost certain that you would have to use VB in an Excel macro).

    In Access you can link to an Excel spreadsheet and treat it as a table, but you cannot make changes to it (i.e. updates), either directly or through SQL. You used to be able to do that, but MS lost a court case a number of years ago, and the ability to update was removed in (I think) A2003.

    You can manipulate Excel spreadsheets through VBA, but the code is tricky and requires opening Excel itself and the spreadsheet as objects in MS Access.

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    I don't think you will find a good tutorial since the subject is too specific.

    You need to learn how to google/bing properly to find what you want. You might try googling something like "Access to update Excel" or similar to find posts on this and other forums on what you want to do. If nothing appropriate comes up, try rephrasing. Also think about your thread title - make it a bit more specific and you will find links to similar threads on this forum - see below

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

Similar Threads

  1. Link excel to access
    By medaccess in forum Programming
    Replies: 7
    Last Post: 04-28-2013, 07:03 PM
  2. One Way Link From Access to Excel
    By dargo72 in forum Import/Export Data
    Replies: 1
    Last Post: 12-06-2012, 01:31 PM
  3. Link Excel to Access problem
    By gg80 in forum Access
    Replies: 1
    Last Post: 02-22-2011, 09:35 AM
  4. link between excel and ms-access
    By Bala Preetha in forum Access
    Replies: 1
    Last Post: 11-28-2010, 08:23 PM
  5. Access link to excel file
    By delkath in forum Access
    Replies: 3
    Last Post: 09-13-2010, 12:28 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