Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



In Access 2007 I need to combine multiple tables into 1 having identical fields

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 17-06-2009
Member
 
Join Date: Apr 2008
Posts: 32
In Access 2007 I need to combine multiple tables into 1 having identical fields
  

Hello,

I am working with Access 2007. I am fairly new with it.
I need to combine multiple tables into 1 having identical fields into a single table.

Is there any simple & easy way to do so?

Reply With Quote
  #2  
Old 17-06-2009
Member
 
Join Date: Jan 2009
Posts: 39
Re: In Access 2007 I need to combine multiple tables into 1 having identical fields

You use an Append query. Make a structure only copy of one of the tables (use Copy and paste).
Then add the identifier.
Now run Append queries for each table into the new main table.
Reply With Quote
  #3  
Old 17-06-2009
Member
 
Join Date: Feb 2008
Posts: 1,845
Re: In Access 2007 I need to combine multiple tables into 1 having identical fields

  • Make a new empty table or choose the existing table to be the central repository of the data.
  • Make a query for all field and records for the first table. Change the query type to Append and select the destination table as the target.
  • Execute the query
  • Delete the source table and replace with the next
  • Repeat the procedure until all source tables have been used.
Reply With Quote
  #4  
Old 17-06-2009
Member
 
Join Date: Jan 2009
Posts: 36
Re: In Access 2007 I need to combine multiple tables into 1 having identical fields

Hi
You need to establish a relationship between the tables. This is really simple in Ms access. You can drag and drop fields from one table to the other to create the relationship.
Code:
SELECT TableA.PrjectNumber, TableA.DVD#, tableb.BobNumber
FROM tableA INNER JOIN tableB ON TableA.ProjectNumber = TableB.ProjectNumber;
http://office.microsoft.com/en-us/ac...963201033.aspx
Reply With Quote
  #5  
Old 09-05-2012
Member
 
Join Date: May 2012
Posts: 1
Re: In Access 2007 I need to combine multiple tables into 1 having identical fields

You can also do a UNION select. SELECT * FROM TABLE1 UNION SELECT * FROM TABLE2 etc.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "In Access 2007 I need to combine multiple tables into 1 having identical fields"
Thread Thread Starter Forum Replies Last Post
Combine 2 Pivot Tables into 1 Master Workbook? DANIEL 602 MS Office Support 1 04-02-2013 10:51 AM
How to Combine and Merge Multiple Documents in Word 2007 SKREECH Tips & Tweaks 6 27-11-2011 04:50 PM
How to create table and Modify tables in Microsoft Access 2007 Antonio1 Windows Software 7 26-11-2009 11:31 PM
How to Automatically access the fields of an Access 2007 forms Corona Software Development 3 25-06-2009 12:54 PM
Need help to combine and merge multiple documents into single in Microsoft Word 2007 sivaranjan Windows Software 2 24-11-2008 04:48 PM


All times are GMT +5.5. The time now is 08:08 AM.