[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

How to copy one table contects into a different table in MS Access 2007?

How to copy one table contects into a different table in MS Access 2007?
0
Troush2009
Asked:
Troush2009
  • 2
1 Solution
 
hindtburnsCommented:
Does the table you are copying to already exist, or are you going to be creating a new table? Are the two tables in the same database?
0
 
PlantwizCommented:
http://www.keystonelearning.com/resources/articles/access_2007_copying_the_table_structure_and_data

Or write a query to insert the table, likely the first two options will be what you wanted.

Let me know if there is anything further.
0
 
Rey Obrero (Capricorn1)Commented:
assuming your table name is A and you want to copy all contents to table B in the same database

using a query

insert into B
select A.*
from A
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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