Help in converting an array into a table?

[Hacktastic]

Hi Guys,

I have an API that fetches data from a URL and posts it into an array format.

I would like to have that array write to a table.

Questions:
Do I need to create the table definition first?

How do I place the data from an array format into a table structure?

Any guidance would be greatly appreciated.

Chris

 

[SkipVought]

Hi,

Check out this faq222-1422

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Hacktastic]

Hi Skip,

I understand, however how will i populate my table with the data i receive that is already in an array?

 

[SkipVought]

Open an ADO recordset using the TABLE.

in a loop, assign each row's array values like...

for i = 0 to ubound(arry)
    rst.Open sSQL, cnn, adOpenDynamic, adLockPessimistic, adCmdTable
                          
    rst.AddNew

    j=0
    for each fld in rst.fields
       rst(j) = arry(i,j)
       j=j+1
    next
                  
    rst.Update
next

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}