Allrighty then.... the next obvious question... Is this on a local hard disk or over a network?

Is the access database compacted?

Other than that I really have no more ideas on how to possibly speed up this process.

Alex


>That is exactly what I am doing.
>
>>Why don't you try to open the tables in Access and export to dbf?
>>
>>Alex
>>
>>
>>>I am trying to pull some tables out of Access and into Fox. (This is more of an Access question so I apologize for being out of place.) The tables have several million records and just a few fields but it is taking several hours (3-8) on each. This seems so out of line to me. Any suggestions?
>>>
>>>Thanks.