#1  
Old 1st April 2007, 02:14 AM
David Guest
 
Posts: n/a
Default 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


Attached Files
File Type: zip Export.zip (1.29 MB, 28 views)
  #2  
Old 7th March 2018, 08:47 AM
DrW DrW is offline
Junior Member
 
Join Date: Mar 2018
Posts: 6
Default

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?
  #3  
Old 7th March 2018, 12:21 PM
Eivind Eivind is offline
Administrator
 
Join Date: Mar 2008
Posts: 145
Default

Quote:
Originally Posted by DrW View Post
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.
  #4  
Old 7th March 2018, 11:07 PM
DrW DrW is offline
Junior Member
 
Join Date: Mar 2018
Posts: 6
Default

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?
  #5  
Old 8th March 2018, 11:34 PM
DrW DrW is offline
Junior Member
 
Join Date: Mar 2018
Posts: 6
Default

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.
  #6  
Old 10th March 2018, 03:21 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Export Tables to CSV files

> 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]
  #7  
Old 12th March 2018, 08:49 AM
DrW DrW is offline
Junior Member
 
Join Date: Mar 2018
Posts: 6
Default

When I run exporttable I get
NexusDB: the operation could not be completed in the allotted time
  #8  
Old 12th March 2018, 09:11 AM
DrW DrW is offline
Junior Member
 
Join Date: Mar 2018
Posts: 6
Default

when I run a SQL query I get the (MEMO) instead of the value.
  #9  
Old 12th March 2018, 11:12 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Export Tables to CSV files

> 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]
  #10  
Old 12th March 2018, 11:24 PM
DrW DrW is offline
Junior Member
 
Join Date: Mar 2018
Posts: 6
Default

exported file for that column in the table is blank


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Embedded Database to csv files Bernard Simmons Binaries 1 19th April 2013 04:57 AM
Export to CSV Malcolm Cheyne nexusdb.public.support.sql 2 14th March 2008 01:31 AM
database tables, still called 'nx1' files ? Chisolm Wilson nexusdb.public.support 3 14th February 2006 09:57 AM
Export Embedded Database to csv files Bernard Simmons nexusdb.public.support.thirdparty 0 21st November 2005 06:59 AM
Files for "Join ? 3 tables ... please help" from SQL newsgroup Henry - AR Binaries 1 27th June 2005 01:30 PM


All times are GMT +11. The time now is 02:17 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.