Populating a database with an array

[programmargorp]

So i have some data in an 1 dimensional array, is it possible to dump this data into a database?

[Paul Johnson]

Yes

(pseudocode)

Call your string "foo"

Dim l as integer ' holds the string length
Dim c as integer ' used for a loop

l = String.Length(foo)

'open sql, test it's good and if it is...
for c = 0 to l
Insert foo[l] into footable
next c

[programmargorp]

i dont understand ur code? =/

[Paul Johnson]

The code is psuedocode (in otherwords, gives you the idea, but won't work by itself). The line l = String.Length(f oo) can be ignored (my bad)

Start the loop at 0
Insert the first member of the array into the database (insert <data> into <datatable>)
Next loop

I'm assuming you're connection to the database is fine

[programmargorp]

thanks for ur help, but dw, i managed to find a way to dump my data into excel, sorry for the hassle.