Excel到关系数据库 - Access 2007 [英] Excel to relational database - Access 2007

问题描述

http://imgur.com/qAjYG

所以我有一个大的平面文件数据库，我需要规范化。上面的图片是患者记录的PK，文本是相关联的代码。我正在寻找一个连接点。文本代码是另一个表的主键，它们的意思是文本表示。

So I've got a large flat file database which I need to normalize. The pic above is the PK of a patient record, and the text are associated codes. I'm looking to make that into a junction table. The text codes are the primary keys of another table, with a text representation of what they mean.

1 9654
1 7840
1 28260
1 4375
2 8409
2 etc.

所以，你可以看到我需要顶部的一个数字每个代码以1到1的方式。我知道这可以做到没有这种暴力的方式，什么是最好的？

So as you can see I need a number in the top row for every code in a 1 to 1 manner. I know this can be done without this brute force way, what's the best?

普通平面文件的代码为1,2,3,4,5,6〜20为列，当然对于许多患者，记录为空白，

The regular flat file has code 1, 2, 3, 4, 5, 6...20 as columns, and of course for many patients the records are blank, what's the best way to resolve this?

推荐答案

您可以在Excel中使用ADO，或者在Excel之后将Excel表链接到Access联合查询使您能够创建一个链接表。

You can use ADO in Excel, or link the Excel table to Access, after that a union query should enable you to create a link table.

这篇关于Excel到关系数据库 - Access 2007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！