Connect to SQL Server 2005 Database. Then from Object Explorer Window, right click on the database which you want to import table into. Select Tasks -> Import Data.
Register Hereor login if you are already a member
You might find this application useful.
You can avoid problems with validation and set defaults for missing values:
Basically you create a template by selecting a table and fields, then paste the data into the Excel application, validate and send.
Defaults values can be NULL, a value, or an Excel formula.
You can create custom SQL too, for example if you have some records that need to be inserted and some that need to update, here is an example of the custom SQL idea:
Only recently released & free to try.
I am just hoping for feedback or suggestions you have for improvement.