Re: Execute SQL against ADO recordset

> Having created an ADO recordset, is it possible to then refer to this a a
> SQL statement?

No.

> For example, having read the Employees
> table in the Northwind database into a recordset, could I then copy this
> to a table in an Access database using a SQL statement?

No. Having said this there has been some posts here about a product that
allows you do exactly this - within the past 2 months. i.e. do SQL
manipulation on the Recordset.
Check Google
I may have it wrong but I believe it does what you want.

But then why bother?
You can do what you want without recordsets using SQL.
You can insert records from one table in one database into another database.
Use a Connection Execute.

INSERT INTO table1 SELECT * FROM otherdatabase.dbo.table2

Stephen Howe


.

Relevant Pages

  • Re: Using For...Each loops when referencing reports.
    ... SELECT tblTx.*, tblTestTx.* FROM tblTx INNER JOIN tblTestTx ON ... 199 is just the ID in your last SQL statement. ... This will now write the exact SQL statement used to open the recordset to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using For...Each loops when referencing reports.
    ... Looking at the SQL statement, I think you're trying to return the records ... from tblTx and tblTestTx where is equal in both tables. ... This will now write the exact SQL statement used to open the recordset to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using For...Each loops when referencing reports.
    ... SELECT tblTx.*, tblTestTx.* FROM tblTx INNER JOIN tblTestTx ON ... '[Print the SQL statement to the immediate window] ... recordset to the immediate window. ... something to do with how I'm using the recordset. ...
    (microsoft.public.access.modulesdaovba)
  • Re: ADODB Connection
    ... name that the database engine can not find in the table, ... > Dim rsUserInfo 'Holds the recordset for the records in the database ... > 'Set an active connection to the Connection object using DSN connection ... > 'Initialise the strSQL variable with an SQL statement to query the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Beginner CRecordset/ODBC question
    ... Fire this SQL Statement at your database, ... Then check to see if Recordset has a record. ... >I am learning how to do database stuff with MFC using ODBC and CRecordset. ... > a row with the new CRecordset data. ...
    (microsoft.public.vc.mfc)