Group:  Microsoft Access ยป microsoft.public.access.externaldata
Thread: primary keys

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

primary keys
bchasse 05.07.2006 00:09:02
I am trying to import data originally set up in an Excel spreadsheet and
everytime I do it I get the following message:

"Error creating primary key on field "ID" (index or primary key cannot
contain a null value)"

I don't understand. Why can't I create a primary key on one of the fields?
How am I going to link the different tables if it won't let me set up a
primary key. It gives me the same message no matter what field I try and
use.

HELP!!!
Re: primary keys
"Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 05.07.2006 00:19:35
Already answered in another newsgroup to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

If you're using Microsoft's web interface to post, you should see an
"Advanced Options" link at the bottom of the page. You can type the names of
the various groups into the Newsgroup box, separating each newsgroup name
with a semicolon.



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"bchasse" <bchasse[ at ]discussions.microsoft.com> wrote in message
news:BEDBAB3E-7860-4C82-AEA3-00351DF466A2[ at ]microsoft.com...
[Quoted Text]
>I am trying to import data originally set up in an Excel spreadsheet and
> everytime I do it I get the following message:
>
> "Error creating primary key on field "ID" (index or primary key cannot
> contain a null value)"
>
> I don't understand. Why can't I create a primary key on one of the
> fields?
> How am I going to link the different tables if it won't let me set up a
> primary key. It gives me the same message no matter what field I try and
> use.
>
> HELP!!!


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net