is there a way in access 2003 to have the database import a file (refresh a
table) at the same time everyday with out having to touch the database.

For example, go out and grab a .txt file and import it, have it replace a
current table everyday at 9am. Keep in mind I will not be there to open or
close the database.

Sage,

Yes. You can make a macro to do the import, using a TransferText action,
and then possibly some other actions such as OpenQuery to move the imported
data around.

Then, you can use Windows Task Manager, or some third party scheduling
utility, to make it happen. The Command Line for the scheduler will follow
this syntax:
"C:\Program Files\...\Msaccess.exe" "C:\YourFolder\YourDatabase.mdb" /x
NameOfMacro

--
Steve Schapel, Microsoft Access MVP


"SageOne" <(E-Mail Removed)> wrote in message
news:FD537CDA-F20D-4405-9705-(E-Mail Removed)...
> is there a way in access 2003 to have the database import a file (refresh
> a
> table) at the same time everyday with out having to touch the database.
>
> For example, go out and grab a .txt file and import it, have it replace a
> current table everyday at 9am. Keep in mind I will not be there to open
> or
> close the database.