I am looking for the best solution for Importing and Exporting data from MS Excel for ERP LN from the client.

Please let me know what is the most cost effective solution?

I would think exchange would be a good plan in LN. Exchange can read and write comma delimited files for excel (watch for the problem with leading 0's in strings though, that's an excel issue). In LN, as in V, you can choose when importing data that it use the DAL validations on your field imports, so when you import through Exchange you will get good field level validations. If you have need of extra logic you can code them in the conditions.

Other ideas depend on how handy you are with tools. You could probably write your own import / export sessions. For export just read the tables and write comma delimited files out for excel. For Import, read the files in, and use the DAL2 calls to put the data in. Not sure of your exact requirements, but from an overview that sounds fine.

Many ways to do, maybe someone else also has ideas.

Anupam,

Lisa's idea might be cost effective.

You can also refer to the following document which should also be available in the Gemini/SSA-ERP-LN version.
iBaanERP 5.2a
Microsoft Excel Integration - Guide
for End Users and Template
Designers

User's and Installation Guide for
SSA® Integration Pack 2.0 for Baan
ERP 5/6 - Microsoft® Office
97/2000/XP
You would have to use BaaN Open World and be licensed/support for it.
To install and configure the Baan OpenWorld Server
The system administrator installs and configures your Baan OpenWorld
server. For information on how to install and configure a Baan OpenWorld
server, see Baan OpenWorld 2.4 - Installation and Configuration Guide for
Adapter forBaan IV and Baan ERP (U8094A US).
To establish a connection between the server and the client, Baan
OpenWorld uses bus components.