将Excel文件保存到SQL Server [英] Save Excel file to SQL Server

问题描述

我有大的excel文件，其中列数是多少如何在SQl服务器中保存它？帮助我.... !!!

I have large excel file where the number of column is varied how to save it in SQl server ??? help me....!!!

推荐答案

我仍然不能在这里提出一个不错的问题。



所以，只是一个提示：



你可以有两个表：一个表代表列，所以列数是可变的，因为你可以添加/删除记录到/从这张桌子。此表不包含有关列下单元格的信息。



另一个表可以表示单元格，每个单元格从列表中引用其列。单元格记录的一个属性是引用列表主密钥的外键。



我忽略了行，因为你没有询问它们。更现实的是，行数也是可变的，有些可以是空的等等。



对于行，与我在列中描述的相同;你需要添加一个或多个表。每个单元可以引用其行，该行具有引用行表的主密钥的外部密钥。因此，每个单元格引用其行/列对。这就是关系模型的工作原理。



这样，3数据库表将重现一个锯齿状电子表格。此外，您可以代表一组电子表格等。

-SA

I still cannot here a decent question.

So, just a hint:

You can have two tables: one table represents columns, so the number of columns is variable, as you can add/remove records to/from this table. This table carry no information about the cells under the column.

Another table could represent cells, each cell referencing its column from the table of columns. One of the attributes of the cell record would be a foreign key referencing a master key of the column table.

I ignored rows because you did not ask about them. More realistically, the number of rows are also variable, some can be empty, etc.

With rows, do the same as I described with columns; you would need to add a table or rows. The each cell can reference its row having an external key referencing the master key of the row table. So, each cell references its row/column pair. This is how relational model works.

This way, 3 database table will reproduce one "jagged" spreadsheet. Additionally, you can represent a set of spreadsheets, etc.

—SA

有YouTube上的完整详细视频只是搜索。 Excel到Sql Server

There is a full detailed video on YouTube just search. Excel to Sql Server

这篇关于将Excel文件保存到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！