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.
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks