I have Excel97 at work and it can open a file made with:
COPY TO myfile.xls TYPE FOX2X
Note the extension. This allows you to double-click on the file in windows Explorer and bring up Excel by association!
Dana
>>Thanks for your quick reply.
>>
>>How do I get the fields to go into separate columns automatically.
>
>Sorry, I didn't notice the part about all the data being in Column1. However, I have opened comma-delimited files and they were split successfully. I am not sure what is going on. Perhaps you should explicitly give the CSV extension.
>
>One alternative would be to use the "parse" option in Excel.
>
>Another would be to switch to DBF format instead of CSV. From VFP:
>
>
>copy to temp.dbf type foxplus
>
>
>FoxPlus is the dBASE III format; Excel can't read VFP tables directly.
Where's the damned Any Key?...too late