How many of all these points can you do successfully? If the answer is none, then I would suggest you search this site for "books" and "videos"

Regards
Tushar

> This is the task:
> *)-------------------------------------------------------------
> *)Add a button to Parent form called 'Import Detail'.
> *) Button will only enable if STATUS (txtStatus) box = 'Started'.
> *) When Clicked popup box - user to confirm import of excel data to header record.
> *) If 'Yes'- invoke file lookup with new Child dialog Window.
> *) Lookup defaults to last used path based on program UserID.
> *) Disk file path will be saved to the Program UTUSER user memo whenever function is envoked.
> *) If new user - current path is Program system path to the Program folder.
> *) When spreadsheet is selected - import each row.
> *) Import from spreadsheet until blank line is found in Account# (Column A).
>
> *) CCA - Validate Account# as valid current GL account (GLMAST).
> *) CCB - If not Valid GL Account 'Error Message - Row will be skipped'.
> *) CCD - Remove any dashes from importing Account#.
> *) CCE - If column Account#(column A) evaluates as number convert to string.
> *) CCF - [Transaction Description] (Column B) must not be blank and must evaluate to string.
> *) CCG - Debit & Credit (Column C & D) must be numeric and one column must be >0 with no value >0 in both.
>
> *) Check Code from CCA to CCG before inserting row into SQL dbo.GLITEM table via document automation.
>
> *) Entries in Debit & Credit (Column C & D) must match. IF NOT EQUAL the VFP Parent Form will require additional line item or change to existing lines to achieve balance before transaction is posted.
> *) Decimal precison is !> M2M currency decimal.
> *) Display MsgBox with a Line count and Credit & Debit sum.
> *)-------------------------------------------------------------
>