How to export data from Excel spreadsheet to Sql Server 2008 table

by

From your SQL Server Management Studio, you open Object Explorer, go to your database where you want to load the data into, right click, then pick Tasks > Import Data.

This opens the Import Data Wizard, which typically works pretty well for importing from Excel. You can pick an Excel file, pick what worksheet to import data from, you can choose what table to store it into, and what the columns are going to be. Pretty flexible indeed.

You can run this as a one-off, or you can store it as a SQL Server Integration Services (SSIS) package into your file system, or into SQL Server itself, and execute it over and over again (even scheduled to run at a given time, using SQL Agent).

Update: yes, yes, yes, you can do all those things you keep asking – have you even tried at least once to run that wizard??

OK, here it comes – step by step:

Step 1: pick your Excel source

enter image description here

Step 2: pick your SQL Server target database

enter image description here

Step 3: pick your source worksheet (from Excel) and your target table in your SQL Server database; see the “Edit Mappings” button!

enter image description here

Step 4: check (and change, if needed) your mappings of Excel columns to SQL Server columns in the table:

enter image description here

Step 5: if you want to use it later on, save your SSIS package to SQL Server:

enter image description here

Step 6: – success! This is on a 64-bit machine, works like a charm – just do it!!

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Syntax combine two stored procedure into one [closed]
  3. How to delete duplicate rows in SQL Server?
  4. CROSS JOIN vs INNER JOIN in SQL
  5. How to cast the DateTime to Time
  6. How can I schedule a job to run a SQL query daily?
  7. Reset identity seed after deleting records in SQL Server
  8. How to avoid the “divide by zero” error in SQL?
  9. Multiple INSERT statements vs. single INSERT with multiple VALUES
  10. Real life example, when to use OUTER / CROSS APPLY in SQL
  11. Common Table Expression, why semicolon?
  12. T-SQL split string based on delimiter
  13. How do I find duplicates across multiple columns?
  14. Generate script in SQL Server Management Studio
  15. sql varchar(max) vs varchar(fix)
  16. Do clustered indexes have to be unique?
  17. How do I prevent a database trigger from recursing?
  18. store arabic in SQL database
  19. Convert Date format into DD/MMM/YYYY format in SQL Server
  20. Converting Select results into Insert script – SQL Server
  21. How to combine results of two queries into a single dataset
  22. Executing SQL Server Agent Job from a stored procedure and returning job result
  23. Restrict varchar() column to specific values?
  24. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  25. SQL Server: +(unary) operator on non-numeric Strings
  26. Use one CTE many times
  27. Bulk insert using stored procedure
  28. Connect different Windows User in SQL Server Management Studio (2005 or later)
  29. How to Select Every Row Where Column Value is NOT Distinct
  30. How to do a case sensitive GROUP BY?

Leave a Comment