thanks :D!

Excellent! Atleast someone knows how to do this without writing code that reads excel documents and then writes it to a database.. >_> that's just plain dumb. Thanks for this ;)

Hi,

I want to insert only some columns data in my sql table. is it possible to insert the limited column data or copy paste it.

Please reply.

thanks,

Pravin Wade

Learn <a href="www.welcomeconsultancy.in">What is Sharepoint</a>

Hi Pravin Wade,

I am a little confused about what you asking though. If you want to insert some columns data in your sql table and leave rest of them as NULL, you can just make your excel format to match with it. If you have existing data and fill up some columes, that I can't think any easy way to do so in that case, I will just create a stage table to have data that you want to fill up and use typical update statements by using the stage table that you just created.

I hope that answers to your question.

Regards,

Kun

HI

I want to learn SQL Server 2005 / 2008. please provide me information regarding level of SQL Server and any perfect book. i am very confused. i want to know difference between DB2 / DKB / DBA / Warehousing and Sql Programmer. Please clarify. and mail me some good books of SQL. My id is : contact.ashish126@gmail.com.

Thanks in Advance



Warm Reg.


Ashish Gupta

I Am still waiting for answer.please help me.

Thnks in Advance

 Warm Reg.


Ashish Gupta

Thank you very much. It is working fine in SQL Server 2008.

Thank you for the feedback Sumanta..

Ashish,

I am sorry for late response for your question. I really can't answer your question because I don't know what your skill level is and also  SQL server is way to broad so that topic that you mentioned is not that easy to cover in a few books though.

If you haven't, I highly recommend going SQL Server user group and ask those questions there and there should be a good people can help you to go to right direction. You can google it  "sql server user group" and pick the local area. If you leave washington DC area, let me know. I can meet you there at the NOVA SQL User group and can give you some recommendation based on my experience.

Personally, I love books from WROX like

http://www.amazon.com/Professional-Microsoft-Server-Administration-Programmer/dp/0470247967

And also I like this book too.

http://www.amazon.com/Microsoft-Server-Administrators-Pocket-Consultant/dp/073562738X/ref=sr_1_1?s=books&ie=UTF8&qid=1337268675&sr=1-1

But that is just administrative part and there is a lot more that I like about SQL books...

I hope you have a great time learning SQL!!

Here's another option, which works great for even more complex data -

It's called ClipTable - a free tool that instantly turns any clipboard data into a SQL Table.

You can find it here - http://www.doccolabs.com/products_cliptable.html

Thanks you so much.......simple and painless...Thanks again

Excel to database tool includes validation of data, multiple task setup and sending the data to a stored procedure!

The software also allows you quickly create a template into which you can paste data.

Templates can be reused and even shared accross a network.

Works fine with SQL Server, Access, MySQL and other databases too.

Well worth a look

Excel to database tool

Thank You, really helpful.

it is a way to import data from excel file to sql database when the the date on the excel file is littel(100 - 2000) records , but when it up to 2000 it a problem ,it is take several minuet's  ,,,, what is the solution in this case ??

rafat - [url=http:\\leansoftware.net]Excel to database[url] will validate & upload 2000 rows in approx 6 seconds, depending on how many columns and current load on the database. It is free to try.

You can use this method with success, but it's not exactly an intuitive process for the light-intermediate Excel user.  XLhub  is a powerful Excel add-in that will easily import Excel data into SQL Server using a wizard driven process that guides you through, step by step.  After you've tied your spreadsheet to a SQL server database, XLhub also allows multi-user access and live edits -- thus tracking each user edits so you know who's done what. You can learn more by checking out their website at www.xlhub.com

A new verion of the Excel-to-database project (allowing copy/paste/validate/send of data) has been released today:

Relese detail (blog) http://leansoftware.net/en-us/blog.aspx

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

New features include the 'Active Legend' :

[img]http://leansoftware.net/Portals/0/ActiveLegend2.png[/img]

Thank you all very much for the interest from this thread :)

60 days Free as usual :)

Thanks

Hi,

I tried the above steps to copy paste data from excel. I am getting the following error:

---------------------------
Microsoft SQL Server Management Studio
---------------------------
No row was updated.

The data in row 17 was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: String or binary data would be truncated.

The statement has been terminated.

Correct the errors and retry or press ESC to cancel the change(s).

**********************

I checked the microsoft support forum and it says that:

 This issue occurs if the following conditions are true:

• The table contains one or more columns of the text or ntext data type.

To work around this issue, create a new query window in SQL Server Management Studio. Then, run a SQL UPDATE statement to update the row in the table.

***********************

Can you suggest what to do when the data is of type "text".

Thanks,

Madhuri