Insert into (table)
Select (data)

Make sure you're selecting in the same order your table's data is laid out.

Colin MacKenzie


-----Original Message-----
From: Mark Irvine [mailto:mark@m...]
Sent: Tuesday, December 03, 2002 10:48 AM
To: sql language
Subject: [sql_language] Multiple Inserts

Hi,

I was wondering if someone could give me some assistance on how to insert
mutliple records into a database in one go.

Many thanks,

Mark