Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I was wondering how can I do it to extract a huge data info from a table into another format that is not QVD.
What I got used to do is to create a table and then "extract it to excel" with the "excel button".
And if I needed to extract it to XML, I do this macro function :
Sub ExtractToXML
set Obj = ActiveDocument.GetSheetObject("TB01")
Obj.ExportXml "C:\Myfolder\MyXmlFile.xml",1200
end Sub
But what about if I the table is not supported by the table itself because of the amount of data?
Is there any easier way to do this?
I insist I need to do it avoiding QVD files, because I need to export the data in another formats.
Many thanks in advance!!
SInce version 9.00, you can store tables within a load script into a delimited txt file, using the same command STORE:
STORE MyTable into MyTextFile.txt (txt);
Thanks Oleg for your quick reply, I'm interested in extract the table directy into xml or excel if it could be possible.
But by now, if I can store it in a txt file, it's Ok.
Thanks Oleg anyway!!!