• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

AUTO SYNC EXCEL DATA WITH ACCESS DB

my title says it all...

i would like to auto sync a spreadsheet with an access db, is this possible? do i need some third party software? if so any ideas where i can find it?

cheers

zac
0
bede123
Asked:
bede123
  • 3
  • 3
1 Solution
 
peter57rCommented:
Hi bede123,

Just by looking at the data, how would you determine which record to accept if there was a difference?
(If you can do it, what rule are you using? If you can't do it then no software can, that's for sure.)

Pete
0
 
bede123Author Commented:
Well when i say sync i think i mean "update", there would never be any collisions. the excel spread sheet would always be the latest version of data

zac
0
 
peter57rCommented:
bede123,

Then just import it into Access when you need it.

If there is no time when XL users and Access users would need to look at the data at the same time you could just link to the spreadsheet from Access.

Both the Import and Link options are on File>GetExternalData

Pete
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
bede123Author Commented:
Yes, i can link the data from access to XL but not the other way round using the above mentioned method, unless i'm doing something wrong
0
 
peter57rCommented:
You only need to link from Access to XL.  There is nothing to do in XL.

Pete
0
 
bede123Author Commented:
Sorted, thanks, dont know why i didnt think of that really!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now