Prompt Table Name from Make Table Query

[gall3on]

I was wondering if there was a way to prompt for a Table name when using a Make Table Query.

I'm basically combining two tables but I want to be able to name that table dynamically as I generate it instead of having to define it beforehand.

Below is my code:
SELECT SourceCodeSearchTable.[Offer Name],
[Matrix+Offer Table].OFFERID,
[Matrix+Offer Table].[Consumer Source Code],
[Matrix+Offer Table].CID,
[Matrix+Offer Table].[BT Offer Code]

INTO [Enter Source Code Table Name]

FROM [Matrix+Offer Table] LEFT JOIN SourceCodeSearchTable ON [Matrix+Offer Table].OFFERID = SourceCodeSearchTable.[New Offer ID];

Thanks!

 

[Remou]

You can do this with VBA, but I do not think that it is possible with Jet SQL.