Import Array into Table

[Lenny_821]

Hi All,

I've got an Array which I want to import into a table. How can I do that?

Lenny

 

[checoturco]

hi Lenny_821,

you may do that with a for cycle

for i=0 to <array_lenght>

docmd.runsql " insert into <table_name> ([field]) values ( <array_name>(i))

next

 

[reclusivemonkey]

Use a "Do While --> Loop" and an SQL Update Query.

 

[Lenny_821]

ok, thanks. I am going to try that.

Lenny