Wrox Programmer Forums
| 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 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
  #1 (permalink)  
Old June 5th, 2007, 03:14 PM
Registered User
 
Join Date: Jun 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linked Excel WS Primary Key?

I've just been assigned the job of linking a bunch of Excel tables to a Microsoft Access Database. I'm creating said database from scratch, and have linked the appropreate worksheets to their tables. This database will be updated thru the Excel sheets weekly, so therefore I needed to link them, and not import. However, I need to create a Primary Key to create relationships in Access. Currently, there are only 3 colums, the name of the feild, the date, and the value for that feild. I wanted to use the "date" column as the primary key, but Access wont let me alter anything in the table once I link it.

I know of no way to create a Primary Key in excel before I link, so how would I go about creating one in Access AFTER i linked the two together?


Thank you in advance...
`Ryan



Similar Threads
Thread Thread Starter Forum Replies Last Post
Foreign key not updating with Primary key xavier1945 BOOK: Access 2003 VBA Programmer's Reference 2 July 4th, 2007 09:48 PM
Primary key cf2006 BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 July 31st, 2006 07:21 PM
FOREIGN KEY and PRIMARY KEY Constraints junemo Oracle 10 June 15th, 2004 01:00 AM





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