insert data in array to sql table vb6

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • parag100
    New Member
    • Feb 2007
    • 13

    #1

    insert data in array to sql table vb6

    i have an array .
    which is already filled with recordset.

    i want to dump this array in a empty sql table

    how to code in VB6?
  • vijaydiwakar
    Contributor
    • Feb 2007
    • 579

    #2
    Originally posted by parag100
    i have an array .
    which is already filled with recordset.

    i want to dump this array in a empty sql table

    how to code in VB6?
    use for loop for each recordset
    create qry liek create table <tblname> as specify the recordset flield name and type here
    commit it
    then do while loop for the current recordset
    create qry to insert data like insert into tblname values all values of recordset
    commit it

    Comment

    Working...