vrs_11,
You are right about what you've said. You need an application engine and file layout to load your data in from a file.

1) You can't load data from an excel file, your will have to convert that to a CSV, or a fixed file.
2) Create your file layout. It is really not that hard, so dive in and read peoplebooks, there are some few good example to help you along the way.
3) Create your application engine and remember to code for your business logic edits before you start inserting data into core tables.

Sorry, but not sure how else I can help. Get started and post any errors/issues you may have along the way. Good luck!

Hi am able to upload the data through app eng and file laout,but wt about the validations....
where should i put a code for uploading a validate data...

define a log file in the code which helps in debugging or putting validations without aborting the file while it encounters a errored row of data.

please find below some peice code of code which helps u in creating log files
&fileLog = GetFile("C:\temp\LOGFILE.log", "w", "a", %FilePath_Absolute);
&fileLog.WriteLine("Begin");
&fileLog.WriteLine("End");
&fileLog.Close();

all the validations are workin fine..tx alot.....
Now i need to create a stat file where 1 can find out how many rows are processe,how many errors and how many rows are succed,,,,,
any suggetions would be helpful to mee