create table from a recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 19 Nov 2005 09:12 GMT

how can i create a table from a recordset in vba ?

Reply to this Message

Allen Browne - 19 Nov 2005 09:18 GMT

Figure out what source statement you used to get your recordset, and turn it
into a Make Table query statement.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> how can i create a table from a recordset in vba ?

Reply to this Message

Sam - 19 Nov 2005 09:31 GMT

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?

> Figure out what source statement you used to get your recordset, and turn
> it into a Make Table query statement.
>
>> how can i create a table from a recordset in vba ?

Reply to this Message

Allen Browne - 19 Nov 2005 10:56 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> don't know how to do it
>
[quoted text clipped - 7 lines]
>>
>>> how can i create a table from a recordset in vba ?

Reply to this Message