• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

Access make table query

Hi

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

Thanks
0
Murray Brown
Asked:
Murray Brown
2 Solutions
 
als315Commented:
Yes, when you select "Make table" query, there is option "Current Database" or "Another Database".
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yes ... Example:


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


mx
0
 
kavik379Commented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now