Methods, computer program products, and systems that schedule loading data into databases

Data is automatically loaded into a user database from an external data source based on a schedule. A determination is made as to whether a task schedule has been satisfied. An application database and the user database are opened using a batch process based on the determination. A macro may be used to load data from an external data source into the user database. A task scheduler may be used to invoke the batch process. The application database may be an Access application database. The macro may remove data from predefined fields in the user database, and then may load data from the external data file into at least some of the predefined fields of the user database. The macro may be used to quit the user database and the application database after the data is loaded into the user database.