Make table query going into another database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to do a make table query to retrieve all the records in a certain
category where the field is named Category. I am choosing Make Table from
the query type drop down list. When the make table dialog box comes up, it
gives me the option to put the table in the current database or another
database. I would like to put this table in another database but after it is
run, I can't find it in either the current or the other database I want to
put it in. The table seems nowhere to be found.

Also, if I do a select query and turn the result set into a make table, how
do I copy the table from the current database to the other database?
 
Hi.
I would like to put this table in another database but after it is
run, I can't find it in either the current or the other database I want to
put it in. The table seems nowhere to be found.
Click to expand...

When you "Browse..." for the location of the database file, Access will
start out in the default directory, which might not be the directory you
think it is. You can check the actual path by selecting the drop down
selector in the "Save in" combo box, or you can open the query in SQL View
and check the path. For example:

SELECT *
INTO tblStuff IN 'C:\Work\MyDB.mdb'
FROM tblJunk;

.. . . where C:\Work\MyDB.mdb is the path and file name of the database where
the table will be created.

Also, if it's a hidden object or system object in the current database, and
you don't have the "Show Hidden Objects" or "Show System Objects" options
checked, whichever is appropriate, then you won't see this table, even if
it's in the correct database.
Also, if I do a select query and turn the result set into a make table, how
do I copy the table from the current database to the other database?
Click to expand...

The easiest way is to select the table in the Database Window, then select
the File -> Export... menu to open the Export Table 'Tablename' To... dialog
window. Navigate to the directory where the other database is located.
Select the "Export" button to open the Export dialog window. Type the name
of the destination table, and select whether you want data and definition or
just definition, then select the "OK" button to export the table.

The second easiest way is to open the other database, then import the table
from the first database. The third easiest way is to open both databases and
copy the object you want in the Database Window with the mouse, then paste it
into the Database Window of the other database. The next easiest way is to
write some VBA code with the CopyObject( ) procedure.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
 
Back
Top