Merging 2 tables - Access
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8038
Printed Date: 30 March 2026 at 12:17pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Merging 2 tables - Access
Posted By: fernan82
Subject: Merging 2 tables - Access
Date Posted: 12 December 2003 at 11:52am
|
I got to tables on an access database that I'd like to merge into 1,
each one has about 30 fields and just 1 record. Is there an easy way to
merge them into one..? Thanks, ------------- FeRnAN http://www.danasoft.com/"> 
|
Replies:
Posted By: adnan248999
Date Posted: 12 December 2003 at 2:21pm
|
Merge as in merge within access or merge as in displaying data from both tables at the same time in asp? ------------- They call me Bruce Lee |
Posted By: michael
Date Posted: 13 December 2003 at 8:47am
|
If they have the same columns you can do a simple UNION query. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: fernan82
Date Posted: 14 December 2003 at 12:05am
|
Merge within access... They all have different fields and 1 record each table, both tables hold the configuration settings for an application, this is a project I just took over an I though I'd merge both tables so I can get all the settings with a simple query rather than a join but I don't think I can anyways cuz I added a few fields to the first table and got an error that there were too many fields or something like that so I guess that's why the guy had them on two tables.... I didn't knew there was a limit on how many columns you could have... Thanks... ------------- FeRnAN http://www.danasoft.com/">
|
Posted By: dpyers
Date Posted: 14 December 2003 at 9:41pm
|
MS Access specifications... http://office.microsoft.com/assistance/offhelp/offxp/access/acmain10/html/acdecLookUpMicrosoftAccessSpecificationsS.htm - http://office.microsoft.com/assistance/offhelp/offxp/access/ acmain10/html/acdecLookUpMicrosoftAccessSpecificationsS.htm ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: fernan82
Date Posted: 19 December 2003 at 1:02pm
|
Thanks, the don't have 255 fields, I read somewhere that everytime you
delete a field the count is not decreased so that must be the reason...
------------- FeRnAN http://www.danasoft.com/">
|