# What happend to simple data export? **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [February 12, 2010, 2:38pm UTC](https://forums.toadworld.com/t/what-happend-to-simple-data-export/9251 "2010-02-12T14:38:12Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 12, 2010, 2:38pm UTC](https://forums.toadworld.com/t/what-happend-to-simple-data-export/9251/1 "2010-02-12T14:38:12Z")
Hey all, Used an old V7 at my last oracle job, and just started a new one and they have 10…quote a difference… One thing I cant find in the new 10 is a simple way to export a list of records from a table… In the old version, you could right click the table name, choose Export Data, and then enter in a where clause, and say where you want the data to go (clipboard or file) and it would generate Insert statements… Cant seem to find that in 10, and the docs dont seem to be much help either… Please tell me they didnt do-away with sucha useful feature, and that I just cant find it in the menus… Thanks! ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [February 12, 2010, 2:46pm UTC](https://forums.toadworld.com/t/what-happend-to-simple-data-export/9251/2 "2010-02-12T14:46:31Z")
If you want to add a where clause, enter your query in the editor with the where clause. Right-click in the grid. Chose “Export Dataset” You can choose clipboard or many different kinds of files. If you want to export multiple tables at once, right-click them from the schema browser, then do “Export Dataset” ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [February 12, 2010, 3:12pm UTC](https://forums.toadworld.com/t/what-happend-to-simple-data-export/9251/3 "2010-02-12T15:12:59Z")
If you want to do it for a table w/o writing a query, use the Data Tab in the Schema Browser, and apply a filter. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 12, 2010, 6:51pm UTC](https://forums.toadworld.com/t/what-happend-to-simple-data-export/9251/4 "2010-02-12T18:51:20Z")
This was exactly what I was looking for, except for fact that when I click on the Dataset tab, I can see the query there, but it wont let me edit it…cant seem to change it in any way… ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [February 15, 2010, 8:48am UTC](https://forums.toadworld.com/t/what-happend-to-simple-data-export/9251/5 "2010-02-15T08:48:28Z")
In the schema browser, On the toolbar above the grid, there’s a “view/edit query” button. Click that and change the query there before you do the export. If you export from the editor, of course you can just change the query there before you export. The reason you can’t edit the query in the export data dialog is that you are also allowed to multiselect rows in the grid before you export, and then export only the selected rows. Re-executing the query with a different where clause would mess that up. However, if you go into the Automation Designer (look for the ‘gear and pencil’ icon on the main toolbar), you can set up an “export dataset” app, and change the query every time. -John ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 15, 2010, 10:28am UTC](https://forums.toadworld.com/t/what-happend-to-simple-data-export/9251/6 "2010-02-15T10:28:12Z")
Thanks John… Its not the ‘simple’ Right click and type a where clause of the older versions, but I guess it gets the job done… Sometimes I guess developers try to add too much power for users and hinder the simpler way things get done… Appreciate the help! Ron ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [February 15, 2010, 10:48am UTC](https://forums.toadworld.com/t/what-happend-to-simple-data-export/9251/7 "2010-02-15T10:48:55Z")