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.