Print Page | Close Window

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/">



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net