I really don't know what else to do Dennis. My access experience is with much smaller tables (couple of thousand recs at most).

Sorry...

Alex


>Local hard disk on a P3 450.
>
>I believe that it is compacted but I know very little about Access.
>
>I looked at one of the other exported tables. It converted long integers into large numeric fields. Since it was appropriate given the nature of the data, I changed these to integer fields which, naturally, shrunk the tables to a fraction of their original size. I suppose that may be a clue.
>
>>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.