>What could be an efficient and fast way of getting data from a Clipper 5.2 table for one time only. Table has too many records. Is there a faster solution than SQL pass through preferably not lowlevel ? TIA.
>Cetin

If it's one time only who cares if it is efficient and fast? How many records are too many?

You could try creating an old style .IDX type index (I don't think this will change the .DBF header structure). Then you could use Rushmore optimized SQL.