Hi NickHK,

I have just get it working. The problem lies with the spreadsheet
itself. You see, there are 900 records in there, and I am not the one
that wrote all those data in. The point is, the data entry person did
some mistakes, there are some fields which is emptied.

It is also my mistakes not to check for empty fields, I will build in
that function after this.

Just wanna say thanx for your help along the way.

And before I go, though that 2 method of creating RecordSet are
different, they have the same result. It's like doing

Dim MyName as String
Dim MyNick$

Regards,
marsulein


--
marsulein
------------------------------------------------------------------------
marsulein's Profile: http://www.excelforum.com/member.php...o&userid=16064
View this thread: http://www.excelforum.com/showthread...hreadid=275204