serigne
asked on
Array to populate Database
How can I use the result off a One-Dimensional Array to populate a Database, each value will have each own row.
Sample :22,25,32,35,50
Field Field2
1 22
2 25
3
4
5
6 50
Sample :22,25,32,35,50
Field Field2
1 22
2 25
3
4
5
6 50
Typo
myvar="22,25,32,35,50"
ssql = "select * from mytable where mycolumn in (" & myvar & ")"
myvar="22,25,32,35,50"
ssql = "select * from mytable where mycolumn in (" & myvar & ")"
ASKER
This will just populate one row, I would like to split the data, with each data having a new row.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you trying to insert the values from an array into a table? Or you are trying to run a select query?
ssql = "select * from mytable where my column in (" & myvar & ")"