Issue 108583

Summary: Support simplified way to export CSV From Base
Product: Base Reporter: megabandwidth <megabandwidth>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: trivial    
Priority: P3 CC: drewjensen.inbox, issues
Version: OOo 3.1.1Keywords: usability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation on: ---
Developer Difficulty: ---

Description megabandwidth 2010-01-22 16:18:35 UTC
Many people need to Export Tables and Queries from Base to use in a different
applications. A simple CSV Export would be great. I can script a little But, I
am not a programmer or i would help fill this gap. If their is a script that
fills this gap I would love to hear a bout it.
Comment 1 drewjensen.inbox 2010-01-23 15:27:30 UTC
There are ways to create a text file from any Base table or query. Depending on 
the data connection type used by the Base file this can be as simple as a single 
SQL command or using Calc as a gateway.

Altered summary - IMO a valid request and one that fits with a few other RFE 
regarding export functionality.
Comment 2 megabandwidth 2010-01-24 06:51:11 UTC
I know you can copy to Calc and Export to a CSV if your data is under 65536
I have a script that Exports small files under 68033 records, if their are more
records then it chokes. The script info can be found here ((if you don't have Xray
installed you will need to comment out line 133.)) for the script to run. 
I need to save around 3500000 records From Table or Querie to CSV file when I
If we can improve the above script or if their is some SQL that will work please
point me in that direction. HELP! Thx,