>when i do this in the command windows : > >Append From ? Type Csv > > >How can i get the name of the csv file to be appended ? > Depends on the source. If the CSV file was generated by Excel,
APPENDFROM (GETFILE('CSV')) TYPECSV
you'll be missing the first record. This is because Fox expects the first line to be the field/column names. Excel doesn't work like that. From Excel 2003, use