Export a large table to MS Excel?

[Former Member]

Hi,

we've a MaxDB custom table table with approx. 100k rec's.

We now want to EXPORT the table to EXCEL or CSV.

We are using SQL Studio 7.6.0.

The problem is, that if we try the export, it starts very slowly and crashes somewhere in the middle (after approx. 1000 rec's).

So how to export/backup a specific table/selection with MaxDB???

[Former Member]

Hello Rainer,

you could use the MaxDB Loader to export a table in a CSV file.

Here is an example how the loader command can look like:

EXPORT TABLE HOTEL.CITY DATA OUTSTREAM FILE 'HOTEL.CITY.CSV' CSV

Regards

Wolfgang

[Former Member]

Thanks Wolfgang.

Can you guide me to the download link of the LOADER tool?

I recently found a 'dead' link on the MySQL site and I could not find any information on the SDN.

Ciao

[Former Member]

Hello,

the loader is part of the MaxDB Installation.

The loader can be started in a command shell and 'loadercli'.

Regards

Wolfgang