Creating an Access Table via an Array using VBA

[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

 

[kjv1611]

Array format? So, you're storing it in a large array variable, or series of array variables, then?

 

[kjv1611]

Oh, and by the way, this one really should be in forum705, assuming you're wanting to build this table in Access.