Results 1 to 5 of 5
  1. 05-10-2016, 10:33 PM #1
    Ribena
    Ribena is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2016
    Posts
    3

    Excel link to Access

    Does any one knows if after linking Excel to Access is there any way where I can allow access to add/ edit the data?
    Reply With Quote Reply With Quote
  2. 05-11-2016, 06:35 AM #2
    NTC
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    a link to an excel sheet is not updateable
    Reply With Quote Reply With Quote
  3. 05-11-2016, 07:04 AM #3
    John_G
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    It can be done through VBA, but it is tricky and requires a good knowledge of VBA. If you don't have Excel, you cannot do it.
    Reply With Quote Reply With Quote
  4. 05-12-2016, 06:55 PM #4
    Ribena
    Ribena is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2016
    Posts
    3
    Hi there, I'm pretty new to this VBA you're talking about would you mind helping me out for this? Thanks!
    Reply With Quote Reply With Quote
  5. 05-24-2016, 07:00 PM #5
    Ribena
    Ribena is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2016
    Posts
    3
    I have excel but I'm not really sure about the vba is it possible for u to help?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Looking to link Access and Excel
    By Lou_Reed in forum Access
    Replies: 2
    Last Post: 05-06-2016, 03:39 PM
  2. Link excel to access
    By medaccess in forum Programming
    Replies: 7
    Last Post: 04-28-2013, 07:03 PM
  3. One Way Link From Access to Excel
    By dargo72 in forum Import/Export Data
    Replies: 1
    Last Post: 12-06-2012, 01:31 PM
  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
  •  

Forum Rules

Other Forums: Microsoft Office Forums