Hello,here goes next part of Excel reader using ADO. Now we will create Two functions identical by result to native functions from Navision 370 table (Excel Buffer).Two functions were created:SelectSheetName(filename);
Function reads Excel schema and shows up dialog with sheet names to select. Let's look at this code (SelectSheetName):
Now we must reorganize previous article function to read data to Excel Buffer (ReadSheet(filename,sheetname)):
So as You can see it's very simple to implement and it works very fast! Try for Your own.Full source code is provided here: http://igor.beeone.googlepages.com/DLJET2a.zip
Very good article. Why don't you upload the ZIP file to our download directory?
I will do this today, I don't know why i made it using googlepages :D Was a late night :D