>>>>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

Yes Enmanuel,
Thanks. That was first I thought if I ever had Clipper :) Anyway solved via SQL pass through.
Cetin