read array into a table

G

Guest

I have calculated data that is stored in an array called DeltaLw. (1 text and
5 numeric fields, variable number of records. Some fields may be empty.) I
want to open a subform that displays the data. I created a temporary table
called TempDeltaLw but can't find a way to read the data from the array into
the table. Any suggestions?
 
G

Guest

I think I found the answer. I added the code:
Set rst = dbs.openrecordset("TempDeltaLw")
With rst
.AddNew
.Fields![Lw 2] = DeltaLw(2, 2)
.Update
End With
I still need to add a loop to read the entire array but this assignment
seems to work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read an array and save the data to a table 2
Insert Statement 2
Table to Array 1
Recordset problem 2
move data from a two dimentional array to a table 1
Copy or addnew from an array 1
Update certain record fields in one table if data exists in anothe 1
how do I write the contents of an array to an access table 11

Top