Persist Array to Table

I am receiving a multidimensional array from outside my application (via web service).  I need to persist this to a table in a database.  Is there is a simple/efficient way to process this array?  The code below is too slow Example1 as it is linear function O(m*n) see Google result: http://pages.cs.wisc.edu/~vernon/cs367/notes/3.COMPLEXITY.html.   Example2 is slightly faster (not as flexible) but it still needs to iterate the maxRow times say 5000.   I am just looking to see if there is a better way to store an array to a table.
'Example 1
    For i = 0 To maxRow
        For j= 0 To maxColumn
            'save to db
        Next j
    Next i
 
    'Example 2
    For i = 0 to maxRow
      MyArray(i,0)
      '...
      MyArray(i,n)
    next i

Open in new window

CyberUnDeadAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Not that I'm aware of ... at some point you must iterate the "rows" of your array, especially if you're not looking to simply dump into a table ... for example, if you must "massage" the data in any way (i.e. make sure a Date exists, or make sure a particular column is not null) then you don't really have a choice.

How often do you do this? I'd think you could process 5k rows pretty quickly, assuming you persist the array to disc before you work with it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CyberUnDeadAuthor Commented:
LSMConsulting:

  Thanks for the reply.   If I wanted to just simply dump to a database or file how would one accomplish that?  Again my data is an multidimensional array say MyQueryBean(rows,columns).   The class below is the structure holding the data.  The class was generated by Microsoft Office 2k3 Web Services toolkit http://msdn.microsoft.com/en-us/library/aa192537(office.11).aspx.  
'struct_QueryBean.cls
Option Compare Database
Option Explicit
 
Public columnList As Variant
Public data As Variant

Open in new window

0
CyberUnDeadAuthor Commented:
I am having the Web Service provider present the data in a different format.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.