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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.