Comparing excel and sales account in sname and then marking for deletion

Legacy Contributor

Hi,

Does anyone know of the commands in VFP9 that will look at an account name in an excel spreadsheet (say column A), then look at sname.sn_account and if the two match, mark the record in sname for deletion?

Thanks in advance,

Bhav

alan-bourke

You would need to get the Excel data into DBF format, and in Excel 2010/2013 you can't save as DBF from Excel any more. You could save it as CSV from Excel and then use the Import Wizard in VFP to get it into a DBF (say called 'mydbf'). Make sure the DBF structure has the account code as C(8).

Then in general you can use:

delete from sname where sn_account in (select accountcode from mydbf)

However you should really perform the same checks as Opera performs before it allows you to delete a sales account via the UI. Does the account have transactions? What about the analysis? What about SOP? Is it referenced in any other location? And so on.