Hi,

I need to add 24 lines into a database, which means that I'll need 24
"Insert Into ..." statements.


---------------
For a=0 to 23
	SQL = "Insert Into...."
	objConn.Execute(sql)
Next
---------------

The data within the Next loop will change, but I want to know if there is a
much better way, and if this is going to kill performance?

Cheers
Craig


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________