>>>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.
>
>Thanks Roger,
>But I care. Otherwise I wouldn't even ask it :)
>My problem is not in creating or not creating an index. I can't use it directly because it's a Clipper 5.2 file with more than 255 fields ;)
>Cetin

I use to work with Clipper prior to move on to VFP. If the problem is the 255 fields limits on vfp I strongly suggest you create a clipper program and export the data to their vfp equivalents. The only difference is the VFP equivalents will be free tables.

Hope this can help you,

Enmanuel