[AccessD] Create Temp Table from Recordset

You can refer to a table in another database within your queries without
having to create a permanent link to that database.
e.g. SELECT * from Orders IN "c:\datafolder\other_db.mdb"
 
Another option might be to use a Pass-Through query.  Once you have the
Pass-Through query running, you can use the Pass-Through query as your
datasource to do whatever you like such as building a make-table query...
This may or may not be a solution for you.  One of its uses is an alternate
way to "link" to a remote database table.  Look in the help file for more
information on "Pass-Through".
 
Not sure if this will solve your problem, just thought it might be something
for you to think about.  
 
Rich

-----Original Message-----
From: ACTEBS [mailto:actebs at actebs.com.au]
Sent: Monday, June 09, 2003 11:13 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Create Temp Table from Recordset


John/Rusty,
 
I don't think I explained myself very well. I have a remote DB not linked to
my FE. I could create a stored query, but it won't run because the tables
are not linked. What I need to do is create the table from the recordset
that I've created so I can work on the data locally and bind it to a report.
 
Any other suggestions?
 
Vlad

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Tuesday, 10 June 2003 12:59 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Create Temp Table from Recordset


do 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/5a75609a/attachment-0001.html>