Skip to Content
0
Dec 28, 2010 at 03:34 PM

Auto Save Exported Excel .txt file

209 Views

My user is on SAP Business One 2007A. We want to export a file to a .txt file using an automatic process in a query. The actions we wish to occur are:

1. Export query data to file

2. AutoSave query as a file on a particular path, with a standard name plus today's date plus .txt.

Is this possible and does anyone have the SQL to implement this in an SBO query?