To maintain long field names and other database features, you can copy to another database. You may need to establish a temporary database just for holding information for your tables, if you want to transfer from one place to another.
copy to Destination database TempDB
>Thanks, that worked for this kind of SQL Query... but obviously the created file is not really there..???
>
>Try
>
>select * from table into cursor CUR_TEST readwrite
>?DBF("CUR_TEST") && returns C:\DOKUME~1\MARVIN~1\LOKALE~1\TEMP\11FW01MA.TMP
>?FILE(DBF("CUR_TEST")) &&Returns .f.
>APPEND FROM (DBF("CUR_TEST")) &&Runs.. and appends
>
>Really weird... behavior is on create cursor files too. Hmm....
>What I need is the Data of those files, badest thing is that we used long names because they are Database Tables, so that a copy to doesn't do the job quite.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)