SQL make table query w/ user defined table name

[joethehoe]

Question for the SQL GODS??

What's the proper(syntax)for a make table query in access where the data base asks the user to input name of the new table??

something like:
SELECT [IS USED FOR MAKE TABLE QUERY].*, * INTO [???enter table name???]
FROM [IS USED FOR MAKE TABLE QUERY];

Thanks Jason.G

 

[SQLSister]

This is a MIcrosoft SQL server forum, not an Access forum. YOu miight find a better answer over there.

 

[joethehoe]

Thanks