After digging in various places on the 'Net, I found what I wanted.
For the sake of anyone else who may be still learning like myself, here's the main portion of what worked for me:
drop table newtable
select * into DATABASENAME.dbo. newtable
there was actually more than that, as my code required two other tables, and their joins AND a delimiter of a date field of the equivalent of "today()+30"
Hopefully, the italics help highlight the fields that apply to individual db's/tables/fields.
Hope this helps someone else.
As a side note, I've come back to this forum and browsed for solutions to other questions as I've been migrating this Access program, and I have to say I HAVE found some of what I've been needing here in this forum.
Thank you to the replies that actually triggered other ideas that led to the solution.