primary key

[bchasse]

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!!!

 

[Douglas J. Steele]

The message is telling you that at least one of the rows you imported didn't
have a value for the ID field.

All fields in a primary key must contain values.

 

[bchasse]

Is there any other possibility that could explain this? When I look down the
row and review it, there is an ID listed for absolutely every record. The
only cell that does not contain a number is the header row and I marked this
accordingly when I tried to import.

 

[ChrisM]

Any chance you are inadvertantly selecting a blank row, or that there is
some 'junk data' in a cell of the spreadsheet below your real data? If there
is, the import routine might be trying to include all the (blank) rows
between the end of your data and this 'junk'.

Cheers,

ChrisM.