Best Way to Create a Table from an Array

[DanSc0tt]

Hi,

Trying to find a way of creating a table and then filling it with values from an array.

Have tried

Docmd.runsql "select into tblName values " & ArrayName

but this doesn't work

Any ideas of

1/ How to fix it?
2/ To do it a simpler way?

Thanks

 

[AlexMidd]

The SQL should be "INSERT INTO [TableName] VALUES {Array elements separated by commas}"

A lot depends on whether your array is one-dimensional or more and how many fields in the table you want to insert the values into.

Have fun! )

Alex Middleton

 

[DanSc0tt]

ugh still giving me a syntax error.

I have this as a part of a loop and so each time it loops I want it to paste in the individual value in the array hence

DoCmd.RunSQL "Insert into tbltest.Test values {" & strArray2(z) & "}"


any more ideas?

Thanks!