<ul>
<li>一个选项是将文件保存到<code>csv</code>,并使用行限制为<code>1,999,999,997</code>的Excel数据模型导入文件。
<ul>
<li>见<a href="https://support.microsoft.com/en-us/office/data-model-specification-and-limits-19aa79f8-e6e8-45a8-9be2-b58778fd68ef" rel="nofollow noreferrer">Data Model specification and limits</a></李>
</ul>
</li>
</ul>
<ol>
<li>在Excel 2016和Excel for Microsoft 365中,使用数据<strong>Get&;转换数据</strong>><strong>获取数据</strong>从任意数量的外部数据源导入数据,例如文本文件、Excel工作簿、网站、Microsoft Access、SQL Server或其他包含多个相关表的关系数据库。
<ul>
<li>在Excel 2013和2010中,转到电源查询<strong>获取外部数据</strong>,然后选择数据源</李>
</ul>
</li>
<li>Excel提示您选择一个表。如果要从同一数据源获取多个表,请选中启用多表选择选项。选择多个表时,Excel会自动为您创建数据模型</李>
<li>选择一个或多个表,然后单击加载</李>
</ol>
<ul>
<li><a href="https://support.microsoft.com/en-us/office/create-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b#:%7E:text=A%20Data%20Model%20allows%20you,source%20inside%20an%20Excel%20workbook.&text=A%20Data%20Model%20is%20visualized,never%20even%20know%20it%27s%20there." rel="nofollow noreferrer">Create a Data Model in Excel</a></li>
<li><a href="https://support.microsoft.com/en-us/office/introduction-to-the-query-editor-power-query-1d6cdb63-bf70-4ae8-a7d5-6ae9547004d9" rel="nofollow noreferrer">Introduction to the Query Editor (Power Query)</a></li>
</ul>
<p><a href="https://i.stack.imgur.com/axowd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/axowd.png" alt="enter image description here"/></a></p>
<ul>
<li>此示例有3M行</li>
</ul>
<p><a href="https://i.stack.imgur.com/2sMZE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2sMZE.png" alt="enter image description here"/></a></p>