Extract large table info into xml, sql or whatever (avoiding using QVD files)

[marcel_olmo]

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!!

[Oleg_Troyansky]

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);

[marcel_olmo]

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!!!