Thanks - that was my estimate also. At least 3 gig hard drive

>My guess is that you will need an additional 2GB of disk space to complete the process. VFP will try to use the memory as much as possible, but I doubt that you have 1GB of RAM! So VFP will create a swap file of 1GB before creating the real table.
>
>>I am working with tables approximately 1 gigabyte in size, give
>>or take a mega!! My problem is that I have to run an SQL on
>>the table that orders it for another application to use.
>>
>>Select * from datafile order by field1 into table xyz
>>
>>How much Hard Drive do I need for this to function? Where
>>do the buffer sit? in memory or hard drive or both?
>>We've already decided to run this off a PC as opposed to
>>off a server in order to speed up the process.