Home > IT Answers > Microsoft Windows > How to upload data from Excel into SQL Server 2005
Ambrish 82
310 pts.
 How to upload data from Excel into SQL Server 2005
Microsoft Excel, Microsoft Excel import/export, SQL Server 2005 import/export, SQL Server import/export
hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav

Software/Hardware used:
ASKED: November 25, 2008  12:59 PM
UPDATED: November 25, 2008  1:53 PM
RELATED QUESTIONS
Answer Wiki:
The following article has a detailed explanation on how to do that using Integrtion Services: <a href="http://blogs.techrepublic.com.com/datacenter/?p=205">How to import an Excel file into SQL Server 2005 using Integration Services</a> And this guide from Microsoft explains how to do it using some other methods: <a href="http://support.microsoft.com/kb/321686">How to import data from Excel to SQL Server</a> Hope this helps.
Last Wiki Answer Submitted:  November 25, 2008  1:53 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You might find this application useful.

You can avoid problems with validation and set defaults for missing values:

http://leansoftware.net/en-us/products/exceltodatabase.aspx

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:

http://leansoftware.net/tabid/123/g/posts/m/23/Excel-MySQL–INSERT-or-UPDATE-Records.aspx#post23

Only recently released & free to try.

 I am just hoping for feedback or suggestions you have for improvement.

Thanks
Richard

rbriggs
 30 pts.