Automate the acessing the table from acess

[vishwadiga]

Hi,



I want to get the data of a table from acess database.

Say DB has got 15 tables..
I want to the data of two tables. I dont want to execute this manually.
I want to automate this job & put the data in the excel?

How i can achieve this?


Thanks
Vishwa

[free_style]

Hi vishwadiga,

You can link the table from Access to Excel and it is really easy.
However, I don't think it is possible to sync the database with Excel (When you enter data in Excel to see it in Access).

You can try this:

1. Create a database in Access (with all the tables and so on)
2. Open Excel. Then from the Ribbon -> Data -> From Access
3. Choose your database from the windows appeared
4. Select the Table or Query you want to use in Excel
5. Select you want to use data from the Tables and then set the range where you want data to be displayed (My tip is use the default range and a new sheet for all the tables and queries you want to use)
6. Open Ribbon -> Data -> Refresh -> Connection Properties
7. In the windows appeared select one or both the options:

• Refresh every (set minutes)
• Refresh data when opening the file

My tip is to use just the second option!

Best wishes