How to schedule data update for an Access table from a SQL database

[egghi]

Hi,

I imported data from a SQL database to create an Access table. Since the SQL database is updated daily, I would like to know how I can link the Access table to the SQL database so that the Access table can be updated automatically whenever new data is added into the SQL database.

Thank you!

 

[PHV]

Why importing data instead of linking ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[egghi]

I was not sure whether I should get external data (from SQL database) by importing data or linking table, and I chose importing data.

If I imported data, does it mean that the Access table will not be updated automatically whenever the SQL database is updated?

If yes, how do I link the Access table I have already created to the SQL database?

Thank you!