Microsoft Excel是一个电子表格程序,允许您在被称为一个工作簿的文档内几张表中列出和分类信息。除了创建列表,还可以根据工作表中的数据制作图表和图形。然而对于更先进的数据功能,需要导入Excel电子表格到Access或一个第三方的数据库程序。
步骤
方法 1 的 4:
在Microsoft Access
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/d\/d4\/Create-a-Database-from-an-Excel-Spreadsheet-Step-1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/d\/d4\/Create-a-Database-from-an-Excel-Spreadsheet-Step-1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
在Excel中创建一个电子表格。
保存电子表格到您硬盘驱动器上的某个位置。您也可以使用现有的Excel电子表格。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/8b\/Create-a-Database-from-an-Excel-Spreadsheet-Step-2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/8b\/Create-a-Database-from-an-Excel-Spreadsheet-Step-2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
启动Microsoft Access。 打开一个现有的Microsoft Access数据库或创建一个新的空白数据库。
Microsoft Access是设计用于与Microsoft Excel同用和捆绑,在Microsoft Office专业版中与Excel一起的。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/1e\/Create-a-Database-from-an-Excel-Spreadsheet-Step-2Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-2Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/1e\/Create-a-Database-from-an-Excel-Spreadsheet-Step-2Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-2Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
您也可以单独购买Access,了解如何从Excel电子表格创建一个数据库。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/55\/Create-a-Database-from-an-Excel-Spreadsheet-Step-2Bullet2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-2Bullet2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/55\/Create-a-Database-from-an-Excel-Spreadsheet-Step-2Bullet2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-2Bullet2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/76\/Create-a-Database-from-an-Excel-Spreadsheet-Step-3.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/76\/Create-a-Database-from-an-Excel-Spreadsheet-Step-3.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击“外部数据”选项卡,并选择功能区上的“Excel ”图标。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/ab\/Create-a-Database-from-an-Excel-Spreadsheet-Step-4.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/ab\/Create-a-Database-from-an-Excel-Spreadsheet-Step-4.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击“浏览”按钮,巡航到Excel电子表格的位置。
或者您可以在字段中键入文件路径,例如:c:/users/<username>/documents/addresses.xls (或 addresses.xlsx) 。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/6\/67\/Create-a-Database-from-an-Excel-Spreadsheet-Step-4Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-4Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/6\/67\/Create-a-Database-from-an-Excel-Spreadsheet-Step-4Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-4Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/e6\/Create-a-Database-from-an-Excel-Spreadsheet-Step-5.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-5.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/e6\/Create-a-Database-from-an-Excel-Spreadsheet-Step-5.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
选择下列选项之一指定如何将信息传输到数据库:
导入源数据到当前数据库中的一个新表:如果您使用一个全新的数据库没有表,或您要添加一个新的表到一个现有的数据库,使用此选项。通过创建一个新的表,您可以在Access中编辑的数据。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/b6\/Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/b6\/Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
追加一个记录副本到表中:如果您正在使用一个现有的数据库,并希望将数据添加到数据库中的一个表,使用此选项。通过附加一个现有的表,您可以在Access中编辑数据。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/50\/Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/50\/Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
创建链接表来链接到源数据:使用此选项,在数据库中创建一个链接,这将在Excel中打开Excel数据库。使用这种方法,您不能在Access中编辑数据。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/d\/d7\/Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet3.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/d\/d7\/Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet3.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-5Bullet3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
选择传输方法后单击“确定”。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/1e\/Create-a-Database-from-an-Excel-Spreadsheet-Step-6.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-6.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/1e\/Create-a-Database-from-an-Excel-Spreadsheet-Step-6.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
从列表选择您想要导入的表。
默认情况下, Excel将创建三个标有“表1 ”, “表2 ”和“表3”的电子表格工作簿”。您可以在Excel中删除,添加和编辑这些表的名字,所做的任何更改将显示在Access中。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/f5\/Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/f5\/Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
您一次只能传送一个表。如果您有三个工作表上都有信息,您必须完成传送一张,然后再返回到“外部数据”选项卡,并为每个工作表重复其余的所有步骤。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/e4\/Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/e4\/Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
选择电子表格后点击“下一步”。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/4f\/Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet3.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/4f\/Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet3.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-6Bullet3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/26\/Create-a-Database-from-an-Excel-Spreadsheet-Step-7.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-7.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/26\/Create-a-Database-from-an-Excel-Spreadsheet-Step-7.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
如果“第一行包含列标题”有选中符号就保留。 如果没有,删除符号, Access将创建自己的列标题。
点击“下一步”。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/00\/Create-a-Database-from-an-Excel-Spreadsheet-Step-7Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-7Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/00\/Create-a-Database-from-an-Excel-Spreadsheet-Step-7Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-7Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 点击“下一步”。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/23\/Create-a-Database-from-an-Excel-Spreadsheet-Step-8.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-8.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/23\/Create-a-Database-from-an-Excel-Spreadsheet-Step-8.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
8
按需编辑字段类型,或表明您是否想导入此字段。
如果您从电子表格中导入所有字段,保持现状,不要在这个屏幕上进行任何更改,然后点击“下一步”。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/80\/Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/80\/Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
如果您想改变某一字段的性质,点击其列标题,编辑字段名,数据类型,或是否被索引。然后点击“下一步”。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/b2\/Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/b2\/Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
如果您想跳过某一字段,在“不导入字段(跳过)” 旁边打对勾,然后单击“下一步”。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/a0\/Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet3.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/a0\/Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet3.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-8Bullet3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/f2\/Create-a-Database-from-an-Excel-Spreadsheet-Step-9.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-9.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/f2\/Create-a-Database-from-an-Excel-Spreadsheet-Step-9.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
9
设置数据库的主键。
为了获得最佳结果,让Access设置主键。您也可以键入选项旁边的文本字段,设置您自己的主键,或者选择“无主键”,但不推荐无主键。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/6\/68\/Create-a-Database-from-an-Excel-Spreadsheet-Step-9Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-9Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/6\/68\/Create-a-Database-from-an-Excel-Spreadsheet-Step-9Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-9Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
点击“下一步”。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/03\/Create-a-Database-from-an-Excel-Spreadsheet-Step-9Bullet2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-9Bullet2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/03\/Create-a-Database-from-an-Excel-Spreadsheet-Step-9Bullet2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-9Bullet2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/57\/Create-a-Database-from-an-Excel-Spreadsheet-Step-10.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-10.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/57\/Create-a-Database-from-an-Excel-Spreadsheet-Step-10.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
10
在“导入到表”字段中键入工作表名称,或让它设置为默认名称。
点击“完成” ,并勾选“保存这些导入步骤” ,以便将来导入时使用相同的步骤。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/fb\/Create-a-Database-from-an-Excel-Spreadsheet-Step-10Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-10Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/fb\/Create-a-Database-from-an-Excel-Spreadsheet-Step-10Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-10Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
单击“关闭”来创建您的数据库。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/a2\/Create-a-Database-from-an-Excel-Spreadsheet-Step-10Bullet2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-10Bullet2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/a2\/Create-a-Database-from-an-Excel-Spreadsheet-Step-10Bullet2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-10Bullet2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
方法 2 的 4:
用Ragic表格数据库软件
方法 3 的 4:
In Ragic spreadsheet database software
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/f7\/Create-a-Database-from-an-Excel-Spreadsheet-Step-11-Version-2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/f7\/Create-a-Database-from-an-Excel-Spreadsheet-Step-11-Version-2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
在Excel中创建表格。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/ed\/Create-a-Database-from-an-Excel-Spreadsheet-Step-12-Version-3.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-12-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/ed\/Create-a-Database-from-an-Excel-Spreadsheet-Step-12-Version-3.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
访问Ragic 账户。 如果还没有,可以免费注册。点击右边“创建新数据库 ”(create new database sheet)来创建一个数据表格。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/27\/Create-a-Database-from-an-Excel-Spreadsheet-Step-13-Version-2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/27\/Create-a-Database-from-an-Excel-Spreadsheet-Step-13-Version-2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
输入表格名,给“用我的Excel创建新表格”( "Create new sheet with my Excel file")选项打钩。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/97\/Create-a-Database-from-an-Excel-Spreadsheet-Step-14-Version-3.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-14-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/97\/Create-a-Database-from-an-Excel-Spreadsheet-Step-14-Version-3.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-14-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
上传文件。 Ragic支持.xls .xlsx 和 .csv 文件。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/07\/Create-a-Database-from-an-Excel-Spreadsheet-Step-15-Version-2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/07\/Create-a-Database-from-an-Excel-Spreadsheet-Step-15-Version-2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
确定第一行是否为标题行。 如果是,Ragic会自动将这行数据映射到下一步骤中表格区域的相应位置。Determine if your first row is the header. If so, Ragic will automatically determine how the data in this row will be mapped to your fields for the next step.
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/35\/Create-a-Database-from-an-Excel-Spreadsheet-Step-16-Version-2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/35\/Create-a-Database-from-an-Excel-Spreadsheet-Step-16-Version-2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
Ragic会自动确认每个字段的类型,如果系统默认的类型不是你想要的,可以手动更改。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/30\/Create-a-Database-from-an-Excel-Spreadsheet-Step-17-Version-2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/30\/Create-a-Database-from-an-Excel-Spreadsheet-Step-17-Version-2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
点击导入,让Ragic创建数据库。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/3c\/Create-a-Database-from-an-Excel-Spreadsheet-Step-18-Version-2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/3c\/Create-a-Database-from-an-Excel-Spreadsheet-Step-18-Version-2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
8
然后你就通过Ragic,用自己的Excel表格创建了一个网络数据库。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/41\/Create-a-Database-from-an-Excel-Spreadsheet-Step-19-Version-2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-19-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/41\/Create-a-Database-from-an-Excel-Spreadsheet-Step-19-Version-2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-19-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
9
你可以用上方的全文本搜索引擎搜索记录。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/86\/Create-a-Database-from-an-Excel-Spreadsheet-Step-20-Version-2.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-20-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/86\/Create-a-Database-from-an-Excel-Spreadsheet-Step-20-Version-2.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
10
或者使用侧边搜索栏,搜索字段组合。
方法 4 的 4:
在第三方数据库软件
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/d\/d4\/Create-a-Database-from-an-Excel-Spreadsheet-Step-1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/d\/d4\/Create-a-Database-from-an-Excel-Spreadsheet-Step-1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
在Excel创建电子表格。 将文档保存为Excel工作簿在一个很容易找到的地方。
您要保存原始Excel文件,手头上有一个主副本。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/04\/Create-a-Database-from-an-Excel-Spreadsheet-Step-1Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-1Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/04\/Create-a-Database-from-an-Excel-Spreadsheet-Step-1Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-1Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/2f\/Create-a-Database-from-an-Excel-Spreadsheet-Step-12.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-12.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/2f\/Create-a-Database-from-an-Excel-Spreadsheet-Step-12.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
点击“文件”,并选择“另存为”。 单击“保存类型”下拉列表,选择数据库程序可以翻译的文件格式。
例如,某些程序使用逗号分隔值格式,而基于网络的应用程序可能使用XML。针对您的数据库计划查找手册,以确定正确的格式。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/6\/6e\/Create-a-Database-from-an-Excel-Spreadsheet-Step-12Bullet1.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-12Bullet1.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/6\/6e\/Create-a-Database-from-an-Excel-Spreadsheet-Step-12Bullet1.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-12Bullet1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3关闭Excel,启动您的数据库程序。
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/5d\/Create-a-Database-from-an-Excel-Spreadsheet-Step-14.jpg\/v4-460px-Create-a-Database-from-an-Excel-Spreadsheet-Step-14.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/5d\/Create-a-Database-from-an-Excel-Spreadsheet-Step-14.jpg\/v4-728px-Create-a-Database-from-an-Excel-Spreadsheet-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
按照手册中的说明导入Excel电子表格到您的数据库程序。