<div>
select * from customermaster where 1=2
</div>


<div>
Give some condition like the above one, which is not matched (1 can never be equal to 2). Hence you always get an empty recordset.<br />
<br />
You can add records to this recordset.
</div>


Give some condition like the above one, which is not matched (1 can never be equal to 2). Hence you always get an empty recordset.

You can add records to this recordset.

<div>
<div class="content wysiwyg-content">
I want to append records to a table using the ADO Recordset. I create my recordset with SELECT * FROM Tablename. The problem is this retrieves all the records before I can do my AddNew's and some tables are massive! How can I do this without retrieving any records? How do you use the &quot;Append-only Rowset&quot; property?
</div>
</div>


I want to append records to a table using the ADO Recordset. I create my recordset with SELECT * FROM Tablename. The problem is this retrieves all the records before I can do my AddNew's and some tables are massive! How can I do this without retrieving any records? How do you use the "Append-only Rowset" property?

APPENDONLY Recordset

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.