create table from a recordset

  • Thread starter Thread starter Sam
  • Start date Start date
Figure out what source statement you used to get your recordset, and turn it
into a Make Table query statement.
 
don't know how to do it

dim rs as recordset
set rs = currentdb.openrecordset("select * from tbl")

now how to turn it into a Make Table query statement?
 
1. Copy the SQL statement (the string inside the quotes.)

2. Create a new query.

3. Switch the query to SQL View (View menu.)

4. Paste the SQL statement in.

5. Switch back to Design view (View menu.)

6. Change to a Make Table query (Query menu.)

7. Switch back to SQL View, and you have your statement to make a table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Checkbox Fields For Every Record 0
Combining Recordsets 5
Recordset in different colour 3
Temporary recordsets 3
Recordsets-Old and New 5
Filter main form to records with no related records in subform,maintain updateable recordset 4
Class Module returning ADODB recordset that can be assigned to forms or controls. 4
Recordset Question 2

Back
Top