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 <ho...@id...>
> 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
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-announce
>
>
|