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

HTH,
Dan

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
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Squirrel-SQL-announce mailing list
Squirrel-SQL-announce@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-announce