CODEWITHSUNDEEP
ms-accesscrystal-reportsexport
Adeem
Adeem

Reputation: 1346

Crystal Report export to MS access

I want to export a data of crystal report into Ms Access as report has almost 2 million records and Ms Excel does not support that much data. Is there any plugin of Crystal report or something to export data without changing my code (as making live the updated code has to go through long process). I am working in Dotnet 2.0 (VS2005)

Upvotes: 1

Views: 2947

Answers (2)

Philippe Grondier
Philippe Grondier

Reputation: 11138

What do you mean by "a data of crystal report"? Crystal Report does not hold data. It just has the ability to connect to a database. Thus, it could be smarter to use ms-access to connect directly to this very same database. Once you're connected, transferring the data to ms-access will be a piece of cake ...

Upvotes: 0

craig
craig

Reputation: 26262

Crystal Reports does not have a Microsoft-Access-export library. You will need to use CSV or TTX.

A better: why do you need to export 2M records? If this is really a requirement, it would be more efficient to do this from the database directly.

Upvotes: 2

Related Questions