Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 6th, 2013, 09:31 AM
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 06:48 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.