Skip to Content
Former Member
Oct 07, 2014 at 10:47 AM

Crystal Report linking MS Excel 2010 to SQL Server DB runs very slow


Hi Folks,

Am a new entrant to this forum and look forward to sharing issues and helping resolve a few!!!

I have a issue on which need assistance: I am linking data in Excel 2010 format to a SQL Server DB using Crystal Reports version xxx. The issue is that the output runs extremely slowly. The excel DB contains approx. 30k+ records and the SQL DB would probably have 500k+ records. The output runs @ 1/2 records per second.

I have been using this method of linking for the last several years with older versions of Crystal and Excel and the output used to be delivered in a matter of minutes. Wondering if the linking methodology has changed since I am still using the old method of linking i.e. through ODBC connection.

Pls help!!!

Best regards...Pradeep