>This type of array is working(array which is not created from afields()), if the fieldnames are small.
>
>I tried using SET DATA TO too, Still it is not accepting long field names

Try a simple test outside.

Open a table that is part of a DBC.

In the command window type,
=AFIELDS( aStru )

Now try
SET DATABASE TO < MyDbc >
CREATE TABLE < NewName > NAME < MyLongTableName > FROM ARRAY aStru

This worked here in VFP 6.0

Let me know if that works for you.