Question Locked

Make faster import to excel file

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How to make faster import data to excel file with crystal report 10 and VB.net,
- i am use crystal report 10,VB.net and SQL Server 2000.

i have 65000 record data.
i want import to excel spreadsheet but i have trouble in performance is very slowly.

could you give me a way to import come faster.

2 replies

by thumbsup2

Importing 65000 records is simply going to take a while. There is no 'quick' way to do it. You could upgrade the computer to the fastest thing on the planet and it's still going to take a while.

You're also importing into a spreadsheet which only holds a maximum of 65536 records (lines), so you're pushing the limit of this tool. You might consider using something else.

This discussion is closed to new replies.