forums Computer Tutorials Computer Help and Spyware Removal File DatabaseUninstall Database Windows Startup Programs Database Computer Resources Computer Glossary Forums Computer Help and Spyware Removal
 

Welcome Guest ( Log In | Click here to Register a free account now! )



Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.
Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

 
Reply to this topicStart new topic
> Merge Access Db Table
lunaz
post May 15 2008, 12:34 PM
Post #1


Member
**

Group: Members
Posts: 19
Joined: 4-March 07
Member No.: 115,450
i have an access db with identical fields (name, address, etc). there is one table for each letter of the alphabet with each group of names in it. there is an automatic id number primary key in each table. unfortunately they all start at 2. there are over 100k records i'm guessing. this data was imported from excel worksheets. when i imported this to access, i tried to get it all in the same table but it didn't work.

questions:
-is there any way to merge all the tables into one? how?
-do i have to reassign the primary key in order for this to not throw up on itself? how?

thanks for any help, i'm new to access, that class 7 years ago doesn't really count. tongue.gif
Go to the top of the page
 
+Quote Post
« Next Oldest · Business Applications · Next Newest »
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Lo-Fi Version Time is now: 5th July 2008 - 06:09 PM


Advertise   |   About Us   |   Terms of Use   |   Privacy Policy   |   Contact Us   |   Site Map   |   Chat   |   Tutorials   |   Uninstall List
Discussion Forums   |   The Computer Glossary   |   Resources   |   RSS Feeds   |   Startups   |   The File Database   |   Malware Removal Guides

© 2003-2008 All Rights Reserved Bleeping Computer LLC.

Powered By IP.Board © 2008  IPS, Inc.