Copy Excel data to SQL server table


What is the easiest way to get data from an Excel spreadsheet into SQL server 2008?
Can you cut and paste like you do into Access?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
hari779Connect With a Mentor Commented:
Using the SQL Server Import and Export Wizard we can copy excel data into SQL Server 2008
jasonbirdConnect With a Mentor Commented:
You can create a link between your SQL database and Excel. If you go into Windows control panel, Admin tools and then ODBC sources.

Add an ODBC connection to the User DSN tab, or Machine DSN if you want it to be available to all users who may use the workstation.

You can now open the tables from External using the External Sources import feature (under the Excel Data tab) and then import "From Other Sources" and select SQL Database. Select the tables you want to be able to access. You can now open them directly from with Excel in an Excel sheet format and you can past data directly into the table.

Good luck
geek_vjConnect With a Mentor Commented:
The best way is to use Import and Export wizard. Here is an excellent article on how to use this step by step: (works for sql 2008 too)
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.