Access : Refresh imported table

Hi zephyr_hex,

There is no refresh concept for  imported data.
You have to import it again.

Pete

ok.
is there a way to automate the import so that it does it itself every so often?

You could link the table rather than importing it.  That may save you some trouble.

Go to File - Get External Data - Link Tables.

i need to have it imported because of how i'm using it.  it won't work as a linked table.

What do you have in mind with 'every so often'
Once a week? Once a day? Once an hour? Every 5 minutes?

Pete

once an hour would do.  or even once a day.

But you wouldn't want Access to start messing around with a table while someone was using it would you?

This sound like it ought to be run on user request, pressing a button.

Docmd.DeleteObject actable, "mytable"
'your import procedure here

Pete

the data pull is only a READ, not a write.  there will never be a case where something in Access gets written to the main database.  i am only using Access for reporting purposes, and i need the data to be relatively current.  i could import the data once a day, but the maintenance of that is going to be a hassle.  i was hoping to automate that import.

a button would not work because the user will not actually be opening up Access to see the data.  i am viewing the Access query/table in Sharepoint.  so the user will bring up a web page, which will make a call to the Access query/table and display the contents.  i have this process working fine on imported data in Access.  so if i could automate the import, then the user would be viewing recent information without someone having to go in and re-import that table in Access every morning.

Thanks!
:)

Jeffrey Coachman