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

Hi,

You could use Excel Automation or retrieve data into VFP directly using Jet ISAM driver for Excel and ODBC or ADO. Here a sample of ADO connection string:
lcConnString = [Provider=Microsoft.Jet.OLEDB.4.0;] + ;
[Data Source=c:\SourceData.xls;] + ;
[Extended Properties="Excel 8.0;"]