distal-attribute
distal-attribute
distal-attribute
distal-attribute

Export large table

User, date Message
Written by spiderplant0
4 years ago
Category: Import/Export
9 posts since Fri, 06 Aug 10
Hi, I cant figure out how to export an entire table. The options under the 'export' menu are 'export database', 'export selected' and 'export grid' (which exports the rows displayed). How do I export the entire table without first displaying all the table rows (as the table is quite big making displaying all rows an issue).
Thanks.
Written by ansgar
4 years ago
4963 posts since Fri, 07 Apr 06
You want "Export database", and then select the table before clicking the "Export" button.
Written by jfalchMoney, Euro
4 years ago
385 posts since Sat, 17 Oct 09
click on the table name in the database tree on heidi.main left side, then select "export database" from the export menu.
In the "table tools" dialog, click on the '+' before your database name, so that its tables are displayed; be sure that there is a check mark only on the database name and on the single table that you wish to export.
select "sql export" tab on the right, optionally select table and output options; select filename, and click on the "export" button.
(if there is a checkmark before the database name, but not before any table name, all tables will be exported.)
Written by spiderplant0
4 years ago
9 posts since Fri, 06 Aug 10
Thanks. I should have tried that menu option!
 

Please login to leave a reply, or register at first.