Help on QBE to SQL

  • Thread starter Thread starter MrDavePet
  • Start date Start date
M

MrDavePet

Many times I use the Query tool to create a query, then I copy the SQL
and execute it from VBA.
I need to create a make table query to make a table in my database
from a table in another database. ( I can do it if I have aI link to
the other table)

I want an SQL statement that will create a table in my database but I
don't want to have the link to the external source table visible in my
database. I'm trying to keep the other database and its location
secret.

Can someone show me how?
 
Back
Top