SQL server with excel as front-end

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
SQL server with excel as front-end

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

February 12th, 2005, 07:05 AM

Stanny

Authorized User

Join Date: Aug 2004

Posts: 26

Thanks: 0

Thanked 0 Times in 0 Posts

SQL server with excel as front-end

Hi All,

I'm building a small application where I use XLS as front and SQL server as back -end.

I have a small form with a listbox but uploading this takes a verry long time (11000 records).First I create an ADODB recordset, afterwords I fill the listbox wih the additem command.

Is there a better way with a better performance ? filling te box takes aprox 50 seconds !!

thx

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple SQL Databases for Same Access Front End	darrenb	Access	0	May 27th, 2008 12:07 AM
Oracle back-end MS-Access 2003 client front-end	Corey	Access	2	February 16th, 2007 08:31 AM
Oracle Back End - MS Access Front End - Multi User	ckaliveas	Oracle	1	February 1st, 2007 06:00 AM
poor perfomance using Access front end to SQL	tanjuakio	Access	24	April 19th, 2005 07:21 AM