Can I import a table of another model (as a static table), only using one script?

[#1]

I need to import a table that is created by a model that i'm not aloud to enter to the script but I can reload the model, so I want to know if someone know how can I run the model, and then export a table previously created to another model. Thanks

[robert_mika]

One way would be:

In front end create table object and add fields from this table only  then export to excel.

(but it will send only first 65K of rows)

[marcus_sommer]

If you export the table like described from Robert to csv you won't be limited by the number of records.

Another way might be to do a binary load from the datamodel and store afterwards your wanted table.

- Marcus

[robert_mika]

Thanks, Marcus,

Is the limitation not dictated by the Excel version you are using?

(65K for Excel <2007 and 1M for Excel >=2007)

Fernando, as Marcus pointed you can do binary load from the qvw but if you experiencing an error during the reload it means that this option has not been disabled on the source data.

[marcus_sommer]

I'm not aware about any limit by exporting into a csv. Actually I have (with AJAX) a table with more than 2 M records exported and it worked well (of course it takes some time ...).

- Marcus