Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 6th, 2013, 09:31 AM
Registered User
 
Join Date: Jul 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Question Create unique identifier for importing Excel into Access

I am currently working on a project, I have created an excel sheet that has multiple tabs with in it, all of which has different data entered into each of the fields in each tab.

This excel sheet gets sent out to clients and they fill out their information into it, and send it back to me.(this process is on-going, so they just use a copy of the original excel file I sent them)

When I receive the excel sheet, I then am importing it into Access, which will store all this information( this access database is storing all information, the excel files are just the temporary storage until imported to Access.

What my problem is that in my excel sheet, 2 of the tabs have to be linked with a unique auto number, but I cannot do that in the excel sheet since it will be used multiple times so the auto number would be the same every time, and the excel sheet it used by hundreds of different people with their individual information.

So for in my Access Database, I import the excel sheets individually for each tab, which goes into pre-existing tables in access.

So my question is, is there a way, in Access, to assign a unique number to 2 different excel imported tabs, without having any duplicate numbers? I've tried just to use a auto number field, but the 2 tables that are linked by the unique number tend to not always line up correctly.





Similar Threads
Thread Thread Starter Forum Replies Last Post
asp excel access unique user_id asad_ahmad Classic ASP Professional 2 January 7th, 2012 02:20 AM
Importing Excel to Access new_kid_in_block Access VBA 1 April 13th, 2009 02:15 PM
Importing from Excel to Access table DeborahP Excel VBA 3 April 3rd, 2007 03:21 AM
Unique Record Identifier peace Access VBA 1 December 6th, 2005 12:03 PM
Updating Unique Identifier foreign key to NULL jraymond VB Databases Basics 0 June 16th, 2003 01:51 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.