>Currently I use Excel to export a spreadsheet to VFP DBF format that VFP can read. Then I read the imported VFP DBF file using a front-end program that I wrote which rewrites the records into a better field structure for reporting purposes.
>
>My question is
>Is there a command or set of commands that I can put in my front-end program that will do the Excel spreadsheet to VFP BDF file conversion automatically and save me that step or will the export from Excel to VFP always be a manual process?
>
>Thanks for the help.

Steve,
What I prefer is :

oExcel = createobject('Excel.Application')
with oExcel
 .Workbooks.Open(lcXLS)
 .ActiveWorkBook.SaveAs(lcDBFName, xlDBF3) && xlDBF3 - 5 ?
 .Quit(SaveChangesConstant)
endwith

Code is off the top of my head. Test first.
Cetin