automatically import file

[SageOne]

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.

 

[Steve Schapel]

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