6:04 How come the ID autonumbering starts at 11 when you paste from the excel? I didn't paste from excel, but my autonumbering starts at 1 and not 11, and I can't edit that field at all since it is set to auto, so how do you get it to start from 11? I think it makes sense that my autonumber ID starts at 1, but it doesn't make much sense that yours skip the first 10 numbers and start at 11.
If you had any records in there before that too numbers 1-10 and then were deleted, Access remembers and will only use new numbers. The only way around that is to create a new autonumber field and start over. Hope that helps!
Great question! In the datasheet view of the table, I highlighted the ID column and clicked and dragged it to the end of the table, all the way to the right. Just make sure all your data is in the same order from the spreadsheet to Access and you should be ok to paste it into the table.
11:31 How come I don't see any of those system tables when I click the relationships button in the database tools?
Good question! The system tables are hidden by default by design.
6:04 How come the ID autonumbering starts at 11 when you paste from the excel? I didn't paste from excel, but my autonumbering starts at 1 and not 11, and I can't edit that field at all since it is set to auto, so how do you get it to start from 11? I think it makes sense that my autonumber ID starts at 1, but it doesn't make much sense that yours skip the first 10 numbers and start at 11.
If you had any records in there before that too numbers 1-10 and then were deleted, Access remembers and will only use new numbers. The only way around that is to create a new autonumber field and start over. Hope that helps!
how did you get the asset Id column to go away right before you pasted the spreadsheet data?
Great question! In the datasheet view of the table, I highlighted the ID column and clicked and dragged it to the end of the table, all the way to the right. Just make sure all your data is in the same order from the spreadsheet to Access and you should be ok to paste it into the table.