create new table from a recordset

[ultimatewilliam]

can i create a new table using a recordset derived from another table? how would i do this?
also, can i create a recordset derived from two or more tables where some fields from these tables are the same except for the data and the table name? thanks!

 

[johnwm]

Look into the Select Into construction. Try this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_md_03_8nad.asp

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'