synchronising excel and access

  • Thread starter Thread starter jonathan s
  • Start date Start date
J

jonathan s

is it possible to synchronise an excel spreadsheet
(created from an access-table) and the original access-
data.
We have a tree-nursery at home, and we've made an
inventory with access. Now I'm wondering if it is possible
to export this data to excel, opening this file on a
handheld Pocket-pc (pocket excel), walking through the
nursery and adjusting what needs adjusting, and afterwards
synchronising this spreadsheet with the inventory.
 
You could try keeping the data in Excel, and link to Excel (through File |
Get External Data | Link Tables. Access will treat the Excel database like
any other table.
 
If you are trying to export the data from Access into excel and keep it on a
pda. I would look at doing the following:

1. setup a macro the exports the data to xls format (this format is designed
for excel)
2. then use a program like "documents to go" and put the excel file on the
list of files to synch.
that way you should be able to keep the data on your pda synched with the
"exported" excel file that you create from access.

If you make changes to the data on the pda, you would have to import it back
into access to keep it synched.

hope this helps,
_Bigred
 
Back
Top