|
Log in |
FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]() 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 |
#2
|
|||
|
|||
![]() 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
|
|||
|
|||
![]() The Enterprise Manager has export functionality by right-clicking the grid in a table view.
|
#4
|
|||
|
|||
![]() 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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]() > 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
|
|||
|
|||
![]() When I run exporttable I get
NexusDB: the operation could not be completed in the allotted time |
#8
|
|||
|
|||
![]() when I run a SQL query I get the (MEMO) instead of the value.
|
#9
|
|||
|
|||
![]() > 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
|
|||
|
|||
![]() exported file for that column in the table is blank
|
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Export Embedded Database to csv files | Bernard Simmons | Binaries | 1 | 19th April 2013 05:57 AM |
Export to CSV | Malcolm Cheyne | nexusdb.public.support.sql | 2 | 14th March 2008 02:31 AM |
database tables, still called 'nx1' files ? | Chisolm Wilson | nexusdb.public.support | 3 | 14th February 2006 10:57 AM |
Export Embedded Database to csv files | Bernard Simmons | nexusdb.public.support.thirdparty | 0 | 21st November 2005 07:59 AM |
Files for "Join ? 3 tables ... please help" from SQL newsgroup | Henry - AR | Binaries | 1 | 27th June 2005 02:30 PM |