Export Tables to CSV files

I have loaded a little utility I wrote to help the arts center move to a
commercial off the shelf set of programs....

It is pretty useful in that it finds your databases and allows you to
export one or more tables from a database. It gives the name of the
file as the tablename.csv.

It also has an SQL window which lets you create SqL's for a database,
run them, save them, load them, and export the results or use the FR4
report designer to put them into a nice looking report. The report
designer can also export to excel or Pdf files.

I have included the source. As for external libraries, it uses Systools
for its export unit and the spawn component and shellshock for its
browser component. Both of these are turbopower libraries available on
source forge...

The program is setup to use TCP/IP to a remote server ...

feel free to do whatever you want with this and I hope some of you find
it useful...

David Guest

[DrW]

the exporttable.exe only exports 31 columns in the table. Mine has 52 columns. Has there been an update to this program or is there a a way I can export the ENTIRE requested table?

[Eivind]

Originally Posted by DrW

the exporttable.exe only exports 31 columns in the table. Mine has 52 columns. Has there been an update to this program or is there a a way I can export the ENTIRE requested table?

The Enterprise Manager has export functionality by right-clicking the grid in a table view.

[DrW]

When I right click I see the options for "Save to HTML, Save to Text, Save to XLS, Save to XML". However when the file is saved it saves with no data. 0bytes. Any chance of fixing the exporttable.exe program?

[DrW]

When I right click and save it comes up as 0bytes. It does not save the info. Any chance of correcting or helping the exportable file? There appears to be a way in the program to run a sql command to only save specific columns in the table but not documented.

> There appears to be a way in the program to run a sql command to only
> save specific columns in the table but not documented.

The EM has documentation online, also there is a full SQL manual
available.



--
Eivind Bakkestuen [NDD]

[DrW]

When I run exporttable I get
NexusDB: the operation could not be completed in the allotted time

[DrW]

when I run a SQL query I get the (MEMO) instead of the value.

> when I run a SQL query I get the (MEMO) instead of the value.

Do you also get that in the exported file?

--
Eivind Bakkestuen [NDD]

[DrW]

exported file for that column in the table is blank