[AccessD] Create Temp Table from Recordset

Messagedo it with the SQL statement directly

Create a make table query using the query wizard and then look at the syntax
in SQL view.

John W. Colby
www.colbyconsulting.com

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of ACTEBS
  Sent: Monday, June 09, 2003 10:48 AM
  To: access group
  Subject: [AccessD] Create Temp Table from Recordset


  Guys,

  Is there a method of creating a temp table in your DB from a recordset?
eg:

  dim strSQL as string
  dim db as dao.database
  dim rst as dao.recordset

  strSQL = "SELECT someTable etc etc etc"

  set db = opendatabase("some remote DB")
  set rst =db.openrecordset(strsql)

  with rst
      make a new table in my db from the recordset
  end with

  I've never had to do this and have wasted heaps of time on this. Any help
will be much appreciated...

  Thanks
  Vlad
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030609/6d183b95/attachment-0001.html>