Export a report with 1.5 mill rows ready for DTS import to MS SQL db

[eo]

That pretty much says it all. Using CR xi r2 on BOExi r2 professional. I can obviously not use XLS as it has a record limit, tried CSV but the format seems to be highly corrupt (it repeats column headers as an example, text seems to be close, but it adds "" on string borders, so this alters NUMERICS to STRING, which is no good, etc.

Any idea what can be used?

EO
Hertfordshire, England

 

[MJRBIM]

What's the DB source for the RPT...?

You might be better off using the SQL from your report directly within a MS-SQL DTS import package, instead of using the Crystal Report as your "Extract-Transform" layer.

 

[IdoMillet]

You can export a report to ODBC...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[groggle]

CR XI R2 and BOE XI R2 have a new CSV export feature.

Read about it by finding boe_xi2_csv_export.pdf at technicalsupport.businessobjects.com

Essentially it allows you to suppress page headers, removing column headings from the export file.