I have a excel file and want to direct import data from this excel file into table using AFS. is this possible in LN 6.1? if yes then how it is possible. This is very very urgent.

ShashiG

Hi Shashi,

Use exchange scheme. That is a better and easier choice.

Thanks Bhushan for prompt reply...

Basically, user has one excel file and i have written AFS for uploading the data from excel to table. My actual purpose is, without using exchange scheme, read the direct excel file (column wise) and insert record into table because user is not any idea about exchange scheme, transfer file from local machine to server and user has not permission all these things. User will only run the sesson and data will upload into table. Hope you understand my problem....

Please suggest any script that is usable me.

Regards,

ShashiG

Have you tried anything? Post your script so that AFS experts can help you.

Here are the threads you can refer:-

Thread 1 (http://www.baanboard.com/baanboard/showthread.php?p=171753)
Thread 2 (http://www.baanboard.com/baanboard/showthread.php?t=30062)
Thread 3 (http://www.baanboard.com/baanboard/showthread.php?t=56184)
Thread 4 (http://www.baanboard.com/baanboard/showthread.php?t=53635)


A proper use of seq* funtions and the job is done. :) And yes, if on LN, try DAL.

Good luck.

i think bhushan has already given the right one. there a other way too... directly creating a dll for updates on table and using this dll functions in excel VBA.