hi,
i want to export to excel or export a text file including timestamp in the name. plz help.
naming a file with timestamp
Hot Topic
Visual FoxPro
- Record repositioning
- MS SQL Server or VFP Database???
- What comand to clear content of General field?
- Memo field conversion
- Preventing key strokes to be passed to control
- Hiding deleted items on grid
- Tolbars and forms with PrivateDataSession
- VFP 9 Form wizard - grid problems...
- How to: Query dbf free tables with cdx
- ? FoxBase Report Form .frm Conversion
naming a file with timestamp
drey
Another way:
use myTable
copy to (alias()+'_'+ttoc(datetime(),1)+'.csv') type csv
Carver42
USE mytable
* prepare or filter or create a cursor from a query or view with the records to export
lcFilename = "MyFile_"+Strtran(Strtran(TTOC(DATETIME())," ","_"),":","")
COPY TO (lcFilename) TYPE XL5