Exporting Access data with batch file

Question

I have an access DB with one table in it and want to export its contents to a txt/CSV file with a batch file and I need to schedule this for every day. is this possible? Someone, please help

Thanks in advance

George

---

George Mathew

Answer 1

I haven't tried it but it looks like someone has a Microsoft Access command line solution for the export:

http://www.tc.umn.edu/~hause011/article/Export_MS_Access.html

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 2

Create a macro to perform the export

The you can use a batch file to launch your db and specify the /x command line switch to run your macro.

Then use a Windows Scheduled task to execute your batch file per your required schedule.

---

Daniel Pineault, 2010-2016 Microsoft MVP
Professional Support: http://www.cardaconsultants.com 
MS Access Tips and Code Samples: http://www.devhut.net