I got the impression from your first post that you were already using Excel automation. Is that not the case? All I was suggesting is that, rather than looping through each line and copying, that you instead use automation to run the "save as" command through Excel.

I don't know the proper syntax, but what I'm suggesting is something along these lines:

oExcel = CREATEOBJECT("Excel")
oExcel.Load("MySpreadsheet")
oExcel.Save("MySpreadsheet","DBF")

Keep in mind that that is very much pseudocode and probably far off from the actual syntax. :) That's why I suggested turning on macros in Excel and see what syntax it uses when doing a save as DBF. Then translate that into VFP.

Does that make more sense?

Michelle


>Michelle:
> I don't quit get the save as command. In order for me to do the save as command, I have to open the Excel file in foxpro. I tried to open the excel file with modi file command. All I got is a text file with unreadable information in it. I tried to do the save as command, dbf file type was not one of the available file type. That was why I asked if I should use the "save as" command in Excel or vfp? thanks.
>sherry