Simple Export/Import query results

[Former Member]

Hello.

I'm trying to export query results using Database Studio 7.9.

It exports something to file without extension.

How can i import it to database or table ?

Default master(Import table) can do this but it needs files(flat files) CSV/FWV/RECORDS/PAGES.

Or how can i DO this flat files ?

[Former Member · Accepted solution]

Hi,

ok the loader is used to export and import data from the database.

If you want to export result sets you can export them into flat files. With Database Studio Export option -> as you show above.

You can define which format these files will have. I would use csv files, then you can import them into other databases or into excel as well.

click in the SQL Editor on your result set -> use EXPORT RESULT

and store the result as *.csv in your local file.

The local file can be loaded into excel or via loadlercli into another database.

[Former Member · Accepted solution]

yea. works fine. thanks.

[former_member600260]

This option is limited up to 1000 results.

[Former Member]

Hi,

you can use the loadercli to export and import data.

Please check documentation about MaxDb Loader

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/04/db5b80e62d4515b4e775ae0730d1e0/frameset.htm

Regards; Christiane

[Former Member]

Thanks for respond.

I'll try this.

But, i mean export(or SIMPLE copy datarows to clipboard) when i've got small query result using native manager!..

It has some instruments for solving export tasks. I dont get how to use it correctly.