Hey Howard,

In newer versions (2.6.7) you can export a SELECT result into CSV / MS Excel format by simply right clicking the results and choosing the option.

Otherwise you can export a whole table as INSERT statements by simply selecting a table from the Objects tree, right click and then Scripts > Create data script. That will generate the INSERT statements in the SQL editor window - keep in mind that if the table is large you need to increase the Maximum Heap Size (-Xmx).


2008/10/1 Howard J. Herman <howard@ideavillage.com>

Is it possible to export using a script or at least using SQL in Squirrel?


This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
Squirrel-SQL-announce mailing list