Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
can anyone tell me in words of one syllable....what is a primary key and how do I create one to allow me to import and merge data from xcel into an existing project plan??? I can get that far but the help in project is crap and i cant get any further.....any help would be appreciated
A primary key is a field in a record, usually an integer, of unique value so you can tell the records apart.
If creating a table from an excel sheet each record would usually correspond to a row, so a primary key would be a column, eg row number. If merging with other tables you obviously need unique numbers for all records in the combined table.
Think need more info before any real experts can help beyond above basics. Is this importing into Access?