If you want to input Excel data in SQL Server database, the important point that you have to pay attention is column table and type data in SQL Server. The column in Excel must be the same as table in database SQL Server.
Ex: If you have File Excel such as below:
Then you should have database table in SQL Server such as below:
If you already have the same File Excel and SQL Server table then follow the step below for how to Import Data Excel To SQL Server
1. Right Click to the database where you want to import the database
2. Choose a Microsoft Excel as data source then browse the file, then click next
Note: in my experience, SQL server 2005 only can read Microsoft Excel data with MS Office 2003 and the old version (xls). When I try to browse the file which is using Excel 2007 (xlsx), it doesn’t work.
3. Choose SQL server Native Client as destination, then click next
4. Choose copy data from one or more tables or views, then click next
5. In Source, tick mark the sheet where you put excel data and in destination choose the table in SQL server, click next and finish
6. You can check the status whether the process Import data success or fail.
Related Topics:
How to connect Delphi to database SQL Server
Select Distinct, Not In and Right Outer Join in SQL Command
How To Import Data Excel To SQL Server 2005
Function Date and Time in Foxpro
No comments:
Post a Comment