URGENT! Help desperatly needed

[mandywoolf]

Hi Everyone, hope you are all ok
Really desperatly need your help please!

I have to import a table from excel which is no problem, but it then goes on to say that i cannot set my primary key to a null value - not quite sure what that means.

I then create another table with 1 field to look up data from the first table. I set the data type to auto wizard and set it all up. No problem. When i do this however, all the data disappears from the first table and i have no idea why!

Please help as this is my assessment and i am really desperate. Any help you could give would be wonderful.

Thank you sooo much
Amanda
xxx

 

[Dave Titan]

Do you have a column with nothing in it on you excel sheet?

Have you tried to create a new header(field) in excel and place a digit in the column?

Once it's imported as a table Access should read it as containing data and then a primary key will have value.