How to persist an ADO recordset from Sql Server into Access

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

Paul
Mon Mar 06 07:15:14 CST 2006

On Fri, 3 Mar 2006 06:11:30 -0800, WayneM <WayneM@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)