Re: How can I build a recordset to insert records into a table

From: Veign (NOSPAMinveign_at_veign.com)
Date: 03/27/05


Date: Sat, 26 Mar 2005 23:44:55 -0500

INSERT or UPDATE statement against the Execute method of the connection
object will work for you..

SQL Guide (bottom of the page)
http://www.veign.com/vrc_app_main.asp

-- 
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
Read. Decide. Sign the petition to Microsoft.
http://classicvb.org/petition/
"bookreader127" <bookreader127@yahoo.com> wrote in message
news:bj0c415uss3p064an8ou7gj3ma8gdlqmcc@4ax.com...
> I have used recordsets quite a bit to hold the results of SELECT
> statements and then added records with that recordset.
>
> I would like to be able to build a recordset just for inserting w/o
> ever using a SELECT statement.  Can that be done?  If so, can you tell
> me the general idea or point me to an article on the web?
>
> Thanks.


Relevant Pages

  • RE: Displaying only 7 records at a time.
    ... whatever error trapping needed). ... ' rst is a Recordset object that will store ... | Content-Type: text/plain; ... Produced By Microsoft MimeOLE V5.50.4910.0300 ...
    (microsoft.public.access.forms)
  • RE: Displaying only 7 records at a time.
    ... | Content-Type: text/plain; ... Produced By Microsoft MimeOLE V5.50.4910.0300 ... | wondering if I did something wrong--it doesn't display ... |> ' rst is a Recordset object that will store ...
    (microsoft.public.access.forms)
  • Re: Edit/Update results in badly fragmented file
    ... Microsoft Jet objects when using DAO in *other* Microsoft Office programs. ... While the article discusses opening a recordset using DAO, ... Public Function ScrubValue (strMPN As String) As String ... Dim blnHasNum As Boolean ...
    (microsoft.public.access.modulesdaovba)
  • Re: Laufzeitfehler 13 beim Öffnen eines Recordsets
    ... Dim XYZ_RS As Recordset 2x Recodrset von IntelliSense angeboten wird. ... Microsoft Jet and Replication Objects 2.6 Library ... Public GL_wrkJet As Workspace ...
    (microsoft.public.de.vb.datenbank)
  • Re: Opening a SQL Server table from within MS Access
    ... Dim rst As ADODB.Recordset ... Depending on what you're going to do with the recordset, ... Unlike a DAO recordset, the default for an ADO recordset ... >I created a Microsoft Data Access Project in MS Access V11. ...
    (microsoft.public.access.modulesdaovba)