how to copy excel spreadsheet data from an excel spreadsheet into a sql server database

I have an excel spreadsheet and I want to copy that data into a sql server table. Either a new table created upon import, or a table I create prior to the import. Whichever is the best technique.

So how do I copy the data from the Excel Spreadsheet to a sql server database? I am using sql server 2008?
LVL 2
brgdotnetcontractorAsked:
Who is Participating?
 
James ElliottConnect With a Mentor Managing DirectorCommented:
Right click on the database on the left hand side of your SSMS window, then select Tasks => Import Data.

From here you can select either MS Excel as the source, or connect via other more specific methods.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
A valid question here is 'Do you have any control over the source data being in Excel?'.

Excel is great in that users can do anything.  Excel is terrible as a source of normalized data in that users can do anything to mess up the formatting so it can't be consumed, causing applications like SSIS and SSRS that require a 'contract' mapping of Source and Destination in order to pump data.

The above SSIS link looks pretty comprehensive.  Would be worth spelling out some of that content in this question.
0
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.