+ Reply to Thread
Results 1 to 3 of 3

Write to Access from Excel ?

  1. #1
    Registered User
    Join Date
    07-20-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    33

    Write to Access from Excel ?

    I have found out that I can import data from Access into Excel using the "Data -> From Access" function, and it works just fine. But what I would like to, is that if I makes a change in the excel file, the change should also be updated in Access. Is this some how possible ?

    I'm using Access/Excel 2007.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Write to Access from Excel ?

    you can use an Excel worksheet as a linked table in Access or you can use code to update an Access table from Excel
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    07-20-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Write to Access from Excel ?

    Thanks, I'll take a look at it

    It works - if I change something in Excel, this will be updated in Access - but not the other way around. I guess this is how it is suppose to be.
    Last edited by spookiepower; 08-05-2013 at 09:05 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Read/Write Access DB from VBA in Excel
    By excelbobabc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2008, 05:45 PM
  2. [SOLVED] Access an excel file through FTP without write protection
    By jj in forum Excel General
    Replies: 0
    Last Post: 10-10-2005, 05:05 PM
  3. Replies: 0
    Last Post: 10-09-2005, 01:05 PM
  4. Multiple Write Access Enable for Excel
    By ravenshroud@gmail.com in forum Excel General
    Replies: 3
    Last Post: 09-23-2005, 03:05 AM
  5. Write value to an Excel VBA variable by reading Access DB?
    By Alan Ibbotson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1