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
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
ASKER
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
zac
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
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
ASKER
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorted, thanks, dont know why i didnt think of that really!
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