Solved

Access make table query

Posted on 2011-03-09
4
241 Views
Last Modified: 2012-05-11
Hi

Is it possible with an Access make table query to make the table in another Access database?

Thanks
0
Comment
Question by:murbro
4 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 250 total points
ID: 35086681
Yes, when you select "Make table" query, there is option "Current Database" or "Another Database".
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 35086682
Yes ... Example:


SELECT Table1.* INTO MyNewTable IN 'C:\aaEE2.mdb'
FROM Table1;


mx
0
 
LVL 1

Expert Comment

by:kavik379
ID: 35086695
Yes. Check this link. Go down to Convert the select query section, step 4, second bullet.

http://office.microsoft.com/en-us/access-help/create-a-make-table-query-HA010108505.aspx
0
 

Author Closing Comment

by:murbro
ID: 35086709
thanks very much
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question