Insert an entire array into a SQL table

How can I insert an entire array into a SQL table without looping through the Array. I am using VB6 and SQL server 2000 - Thanks!!
dmwilson34Asked:
Who is Participating?
 
CyrexCore2kConnect With a Mentor Commented:
If the array is dynamic in size you will have to loop through it.
0
 
Mikal613Commented:
Make a Comma Deleimited Line with all your values

INSERT INTO sal_emp
    VALUES ('Bill',
    '{" & YourLine & "})'
0
 
dancebertCommented:
Is the array one dimensional?  
Do you want each element of the array to become a record?
Do you want each element of the array to become a field in a record?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.