I appreciate your help. Thanks.

I tried exporting to a tab delimited text file and importing into a table. That allowed me to import into integer type fields and sped things up. However, this data I am working with scares me. I felt that the direct export to a DBF might be safer.

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