W
widman
I use a softare that was written in Access. I don't have direct access to
the real database, but it has a funcion with a query that creates an
accesable database for the time period or tables that you request.
I copied that database to my notebook and imported three sheets into Excel,
where a 4th sheet extracts, summarizes, etc. the information from those
tables. I see that Excel (or windows or access) created copies of those
tables in a folder called "my Data Sources".
Three questions:
1. How can I transfer this (and it's sources) to my accountant's computer
in the office so he can update it monthly?
2. When you click "refresh data" in Excel, does it just refresh from "My
Data Sources" or does it cause those tables to be updated from the original?
3. If it only refreshes from the tables in "my data sources", how do I
refresh those tables?
the real database, but it has a funcion with a query that creates an
accesable database for the time period or tables that you request.
I copied that database to my notebook and imported three sheets into Excel,
where a 4th sheet extracts, summarizes, etc. the information from those
tables. I see that Excel (or windows or access) created copies of those
tables in a folder called "my Data Sources".
Three questions:
1. How can I transfer this (and it's sources) to my accountant's computer
in the office so he can update it monthly?
2. When you click "refresh data" in Excel, does it just refresh from "My
Data Sources" or does it cause those tables to be updated from the original?
3. If it only refreshes from the tables in "my data sources", how do I
refresh those tables?