DiscussWorldIssues - Socio-Economic Religion and Political Uncensored Debate - View Single Post

**pageup85** · 05-20-2010, 05:58 PM

Without knowing exactly what you're trying to do (more data would be helpful), one idea is to use Windows Task Scheduler to start whatever application you want to run at a specific time. What application that would be depends on the source of data you're trying to convert and what you're trying to convert it to. Not knowing that, all I can tell you is that you can write macros in Access to import data in one format, run conversion queries on it, and save it out in a different file format. You can command Access to send out emails at the end of a routine or you could use Task Scheduler to do that also.

05-20-2010, 05:58 PM	#4
pageup85 Join Date Oct 2005 Posts 534 Senior Member	Without knowing exactly what you're trying to do (more data would be helpful), one idea is to use Windows Task Scheduler to start whatever application you want to run at a specific time. What application that would be depends on the source of data you're trying to convert and what you're trying to convert it to. Not knowing that, all I can tell you is that you can write macros in Access to import data in one format, run conversion queries on it, and save it out in a different file format. You can command Access to send out emails at the end of a routine or you could use Task Scheduler to do that also.
	Quote