将Excel转换为规范化数据库 [英] Converting Excel to Normalised Database
本文介绍了将Excel转换为规范化数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在尝试从链接的Excel文件中创建一个规范化的数据库作为通用数据库。
假设Excel文件是
I am trying to create a normalised database from a linked Excel file as a general purpose database.
Suppose the Excel File is
展开 < span class =codeDivider> | 选择 | Wrap | Line数字
推荐答案
嘿Phili，
你能解释一下这个更好吗？我想？如果您自己创建了表（并自己建立了关系），那么在导入过程中一切都会很好。我个人并不关心MsysRelationships所说的内容，因为有时Access会创建自己的名字？如果真的需要，以后可以随时更改。
数据导入不正确吗？
Hey Phili,
Could you explain this one a bit better? I ?thought? that if you have created the tables yourself (and established the relationships yourself) that all would be well during the import. I personally don?t care what MsysRelationships says, because sometimes Access creates its own names?that can always be changed later on if we really need to.
Is the data not importing correctly?
你好Twinnyfo，
对不起，解释不明确。
我正在尝试创建一个可以合并的通用Db。进入客户端的Db导入/链接一个或多个Excel文件，扫描这些文件并将数据放入客户现有的表格中。
现在这样做，这些表必须以一定的顺序构建，并且要填充的第一个必须是没有外键的那些（链的末尾）。
因此在上面的示例中，没有任何东西取决于TblStates，但TblCities依赖于知道状态（StateID）。
同样，TblAddress需要正确的城市，因此相应的CityID必须是在填充TblAddress之前建立。
Hi Twinnyfo,
Sorry the explanation was not clear.
I am trying to create a general purpose Db that can be "incorporated" into a client''s Db to Import / Link one or more Excel files, Scan those files and put the data into the Client''s existing tables.
Now to do that, the tables have to be built up in a certain order, and the first ones to be populated must me those with no Foreign keys (end of a chain).
Hence in the example above, nothing depends on the TblStates, but the TblCities relies on knowing the State that it is in (StateID).
Likewise, the TblAddress needs the correct city, so the appropriate CityID must be established before the TblAddress can be populated.
所以，现在你的项目很有意义（这和往常一样令人惊讶），但我不确定问题是什么，因为事情看起来应该是你的照片。
可能是一个例子：
So, now your project makes sense (which is amazing, as usual), but I am not exactly sure what the problem is, as things look as they should from your pic.
perhaps an example of:
表名在szObject列或szRefe中似乎是任意的renceObject列。
the Table names seem to be arbitrarily in the szObject column or the szReferenceObject column.
这可能会有所帮助吗？
That might help?
这篇关于将Excel转换为规范化数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
