Hi!

Take a look to APPEND FROM command in the help - it allows importing of data from different formats. You can also use ADO to open Excel file and work with data through ADO, or convert ADO recordset into VFP cursor.

HTH.

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