I am an end user with "super user" permissions. I downloaded the Excel Column Exporter and imported it into a copy of our Navision 3.6 database to try it out. When I try to use it, I get a message that I do not have permission to do so. Does this only work with a developer's license? If not, do you have any suggestions?
Is it possible to improve the export speed to excel? I've got a table (78 columns) with about 8.000 records and i takes over 1 1/2 hour to export this data to excel.
Wen i run the from to export & import data. after i run im gettin an error "RecordRef is not closed. It should be closed before opening a new table"
Kindly give a solution for this. Even after closing the recordref im still gettin error if i try to save the filter. Also not able to import compilation error occurs.
Comments
Thank you in advance,
Larry Smith
You can use this How To ( http://www.mibuso.com/howtoinfo.asp?FileID=1&Type=howto ) or this Download ( http://www.mibuso.com/dlinfo.asp?FileID=299 ) to determine your object range.
TotalRecNo := IntTable.COUNTAPPROX;
---> TotalRecNo := IntTable.COUNT;
FOR i := 1 TO 999999 DO BEGIN
---> FOR i := 1 TO TotalRecNo DO BEGIN
Explanation :
It's better to proceed only existing records, so using TotalRecNo (filled with exact value by COUNT code) decrease export time.
( http://www.mibuso.com/dlinfo.asp?FileID=350 )
Export to txt and then copy to Excell. How much does it take ?
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Kindly give a solution for this. Even after closing the recordref im still gettin error if i try to save the filter. Also not able to import compilation error occurs.