Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
magictech
Starting Member
44 Posts |
 Posted - 2003-06-22 : 16:06:47
|
| I'm trying to insert data from an ADO recordset into SQL Server table. I understand there are other ways to insert data into tables, i.e. DTS, BCP and T-SQL. However, using ADO happens to be the most suitable approach in my situation.Here is the code that I'm having problems with. Does anyone know how to insert data into a SQL Server table from an ADO recordset? Please any help would be greatly appreciated. Thanks in advance'******************************Do While Not oRs.EOF Insert molap.dbo.holap oRs.MoveNextLoop'******************************* |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-06-23 : 10:53:18
|
| Seems odd to pass judgement on suitability if you're not sure how to use the method ...It depends on how you obtained the recordset. If it's a dynaset then you can update it in place and call update() or batchupdate() to push the changes to the rowset provider.If it's not a dynaset then you would have to create the appropriate insert statements and pass them to the rowset provider.Jonathan{0} |
 |
|
|
|
|
|
Inserting data from an ADO recordset into a table