Is there a simple way to persist a recordset from a SQL Server db into a
table in an Access database, for example DAO
allows a "select * into tablex in 'c:\externaldb.mdb' from..."

Or is a disconnected recordset the way to go, but then how do I persist this
back into another table in an Access database or even a file?

Thanks in advance,

WayneM

On Fri, 3 Mar 2006 06:11:30 -0800, WayneM <Way***@discussions.microsoft.com> wrote:

¤ Is there a simple way to persist a recordset from a SQL Server db into a
¤ table in an Access database, for example DAO
¤ allows a "select * into tablex in 'c:\externaldb.mdb' from..."
¤
¤ Or is a disconnected recordset the way to go, but then how do I persist this
¤ back into another table in an Access database or even a file?
¤

No there is no simple method once the data is in a Recordset. You will need to write code to add
each record, row by row, to the database.

You could try exporting to XML and them importing to Access but you need to be aware of the
following issue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;285329


Paul
~~~~
Microsoft MVP (Visual Basic)

connection.close vs. connection.dispose
Locking a record in Access from vb.net
SqlDataReader 2.0
System.Transactions stored procedure returns NULL value
Populate DataTable rows as it come?