Is it possible to schedule SQLs written for a paradox database?

Is it possible to schedule SQLs written for a paradox database? I have written four SQL scripts to extract weekly data from a few paradox tables. As of now, I am running these queries manually and exporting the result set into text files using the export facility of Paradox. Is it possible to automate the whole process to save time and reduce the chances of any error(s)?
You can always automate things! You just need to create a Windows Service application, that will run the scheduled task. When it runs, you can just connect to the paradox database using ADO.NET and extract the data directly. Check my previous answers: http://searchvb.techtarget.com/vsnetATEAnswers/0,293820,sid8_gci951954_tax293673,00.html and http://searchvb.techtarget.com/vsnetATEAnswers/0,293820,sid8_gci996548_tax293673,00.html.
This was first published in August 2004

Dig deeper on Win Development Resources

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: