View Single Post
  #2 (permalink)  
Old September 27th, 2007, 11:46 AM
BrianWren BrianWren is offline
Friend of Wrox
Points: 5,269, Level: 30
Points: 5,269, Level: 30 Points: 5,269, Level: 30 Points: 5,269, Level: 30
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 1 Time in 1 Post
Default

There is no "bulk insert" functionality.

To insert these data you should open a recordset, use the .AddNew method, fill in the fields’ values and .Update the recordset.

An alternate way is to sumbit SQL against the DB for each element something like:

INSERT INTO <tableName> (Fld1, Fld2, Fldn
VALUES ( """ & Array(n)(0) & """, """ & Array(n)(1) & """, """ & Array(n)(n) & """"
Reply With Quote