Hi Friends,
Hi All,
We managed to read and import the excel data to Excel Buffer table using the below functions,
FileName:='D:\CurrExcel.xls';
SheetName:='CurrencyExcel';
Excelbuf2.OpenBook(FileName,SheetName);
Excelbuf2.ReadSheet;
Now i have the below mentioned data in Excel Buffer table (No.370). Can some body let me know how to transfer this data to Currency Exchange Rate table (No.330) using a codunit and how to do field mapping. We would like to do this by using codunit because we want to schedule it in Job Que.
Row No. Column No. Cell Value as Text
1 1 GBP
1 2 28/04/11
1 3 0.59
2 1 AUD
2 2 28/04/11
2 3 0.91
and so on..........
Appreciate your help.
Thanks,
Ashish Kokney
*This post is locked for comments
I have the same question (0)
