A nice feature of excel is the CopyFromRecordset method. You can transfer a whole recordset in one line of code. This increases performance a lot.