如何将Excel文件导入SQL Express ??? [英] How do I import Excel file into SQL Express???

问题描述

您好，


我是SQL的初学者，想要将Excel文件导入SQL，但我不知道从哪里开始。 Excel文件是一个小公司目录，名称，地址等，不是太大。


任何帮助将不胜感激!!!!

解决方案

hi ..

我的adivice不使用excel，创建一个MS-Access数据库并将其导入到sql ..

谢谢你的帖子。


假设我能够创建MS Access数据库，将此文件导入SQL有哪些步骤？


谢谢

1 。右键单击任何数据库

2.select TASKS 然后选择 IMPORT DATA 点击

后会出现这一个对话框，点击下一步

3.选择 MICROSOFT ACCESS DATA SOURCE，然后浏览你的访问文件然后点击下一步

4.选择目的地[SQL本地客户]

5.选择 SERVERNAME

6.有两个 AUTHENTICATION ，选择 SQL SERVER AUTHENTICATION 并提供USERNAME& PASSWORE

7.选择数据库，然后单击下一步

8.选择从一个或多个表格或视图中复制数据 ; 然后单击下一步

9.在此处显示您在访问中创建的表格

10.选择要插入的表格然后单击下一步

11.选择立即执行复选框，然后单击下一步

12.click完成

13.如果没有错误，需要一些时间来处理和结束，它会成功执行

成功，否则会显示错误消息

Hello,

I am total beginner to SQL and want to import an Excel file into SQL but I''m not sure where to start. The Excel file is a small company directory, names, addresses etc., not too big.

Any help would be greatly appreciated!!!!

解决方案

hi..
my adivice is dont use excel, create a MS-Access data base and import that into sql..

thanks for the post.

Assuming I am able to create an MS Access database, what are the steps to importing this file into SQL?

thanks

1.right click on any database
2.select TASKS and then select IMPORT DATA after clicking
this one dialog box will appear,click NEXT
3.Choose MICROSOFT ACCESS as DATA SOURCE,then BROWSE ur access file then click NEXT
4.Chosse the DESTINATION[SQL native client]
5.Select the SERVERNAME
6.There are two AUTHENTICATION, select the SQL SERVER AUTHENTICATION and give the USERNAME & PASSWORE
7.Select the DATABASE and then click next
8.select "COPY DATA FROM ONE OR MORE TABLES OR VIEWS" then click next
9.the tables what you created in access will be showed here
10.select the tables which you want to insert and then click next
11.select the "EXECUTE IMMEDIATELY" check box and then click next
12.click finish
13.it takes some time to process and finallY, if there are no mistakes,it executes
successsfuly else it shows the error message

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