>>A temp 'table' works if I create the structure without the autoinc column, append from the text file that doesn't contain the autoinc column, and then append to the 'actual' table from the 'temp' table.
>>
>>Append from the 'cursor' doesn't work directly - the append command doesn't seem to support the alias matching the cursor name. If I hack and use the temporary filename of the cursor, ie.,
>>
>>APPEND FROM C:\DOCUME~1\FLN\LOCALS~1\TEMP\I7X002YW.TMP
>
>APPEND FROM DBF('CursorAlias')
>
>>
>>then it will append. I don't like the latter solution (hack), and I also don't like the former, either - if the destination table is in a DBC with long field names, then I need to create the temp table in a DBC so I can have the long field names match for the append command.
>
>No need for that. VFP cursors can have long field names. CREATE CURSOR xyz (LongFieldName C(20))

dbf('cursoralias') works (can't believe I missed that). Ditto on the long field names in cursors - thats why I wanted to use a cursor.

Thanks,

Franz