Click here to Skip to main content
15,943,210 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello Friends,

I have small query please help me out. i want to import or fetch data excel sites to sql server database.

I try import data excel to sql server in sql server import wizard through but it's take on last saved data no take updated data.

I want to live stream data excel sites to sql server database so can you give me any Link's , Example or demo to c# and Asp.net related Send Every second update in sql server to update data.please please friend give me fast reply it's urgent.

Any Example or demo Available so send me my mail account DELETED@gmail.com


Wait ur reply,



Thank you For Reply..
Nirav Kankhara,

[Edit]Removed Email address[/Edit]
Posted
Updated 7-Feb-13 2:07am
v2
Comments
__TR__ 7-Feb-13 8:08am    
Do not post your email address in any of the forums. You will receive a notification email when someone replies to your post.

1 solution

For import Excel Data to SQL DataBase you must be use providers (or) drivers.

Better you can use OLEDB provider to achieve this ..

Go through this links to achieve your goal..

http://support.microsoft.com/kb/321686[^]
http://www.66pacific.com/sql_server_import_from_excel.aspx[^]

As per my knowledge you can achieve this in several way's...
1) first of all you create the connection for OLEDB provider, then you can upload the excel data into GV.
2) you have a data in your DataSet, so using GetXML() method you should convert DataSet data into XML data , in your SP wise do the looping conditon for inserting data..
(or)
using that dataset , in page wise you can use foreach condition inside of that you write the insertion query for inserting the data.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900