Dataport: records one after the other in same file.

Aravindh_Navision

Hi Friends,

I need to create one dataport object and the same object will be used in many databases and companies. I need to create a text file/excel file in one particular path say c:\Test1.txt. While running the dataport object in all databases seperately one after the other, the details should be fetched and saved in the Test1.txt file like one after the other records preceding with company name.

Fields:

Column 1: Company Name
Column 2: "G/L Account"."No."

For example:

Output should be:

Company1,12121
Company2,13131
Company3,14141

Could anyone please let me know how to proceed with this?

Thanks and Regards,
Aravindh R.

Luc_VanDyck

I suggest you create a new table and collect all data first. I understand that the data resides in multiple databases as well. If you are on SQL, you can use ADO or linked tables to retrieve that data. Finally you create your dataport to export the data in the way you like.

David_Singleton

Just loop though the company table, and change company on the required table on each iteration.

David_Singleton

Luc Van Dyck wrote:

...I understand that the data resides in multiple databases as well. ...

Oops I missed that bit. :oops: