在 MS ACCESS 2007 中创建没有主键的表
我可以这样做吗?
我想这样做的原因是,我从 csv 文件导入数据以进行访问,在导入过程中,它会在访问中的自动编号方面产生很多问题。
无论如何,这些表都不会链接起来
Can I do this?
The reason I want to do this is, I am importing data from a csv file to access, and during the import process it creates a lot of problems with the autonumber in access.
The tables are not going to be linked in anyway
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
主键不是强制性的。如果您不需要,请不要添加!
A primary key is not mandatory. If you don't want one, don't add one!
是的,但请考虑在导入完成后将其添加回来。否则,您在尝试进行编辑、删除等操作时可能会遇到问题。如果您希望在导入后能够编辑或删除记录,那么您将需要一个主键。如果您在导入后只需要对数据进行只读访问,那么没有主键应该没问题。
Yes, but consider adding it back when you're done importing. Otherwise you may run into issues when trying to do edits, deletes, etc. If you want to be able to edit or delete the records after you've imported, then you'll want a primary key. If you just need read-only access to the data after import, then you should be fine without a primary key.