What is the quickest way to add data to an sql table. In jet, I would do the following
do while !eof(source)
tbl!fld1 = data1
tbl!fld2 = data2
I am not sure how to do this in SQL efficiently. I am doing it with a SQL RDO and opening an rdoresultset, and using the same procedure outlined above, but it is **very** slow. I am not sure what direction to take.