Hi,
I'm new to Infor LN. Currently I'm using Infor LN 6.1
My question is how to write a session that read data from database then write it to the .txt file ?
Anyone have any suggestions or ideas for this ?

Thank you in advance.

There are several options to do this, depending on the complexity of the data you want to write to a file:
- If all data is in an overview session, just use the Excel export that comes with Enterprise Server 8.7.2.
- If you need to grab data from different tables, write a print session and a simple report and save the report to a file.
- More complex: write the file yourself with the seq... functions.

First of all, thank you for the reply...
The solution is very helpful to me and we are working on it.

Prior to this, I have one more question which how to store the data from excel file to LN Database since I don't have any access to the physical Database in LN.

Hope can hear any good news from this forum...

Hi,

You can read data from the excel file and then insert or update it through querry according to your requirements. You can find lots of scripts on this baanboard for reading data from a file.








Regards

Dhruv