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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QBE 3
Append query in Access to SQL Server 2
Help With SQL Update 1
Can't see existing table in Design view for a QBE 6
Make Table Query to external ODBC SQL Server database 17
Question on Pass-through Query 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
query links to SQL server and mdb table 1

Back
Top