Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 7-Feb-13 2:03am
Nirav88412
Edited 7-Feb-13 2:07am
__TR__28.9K
v2
Comments
__TR__ at 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

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  

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



Advertise | Privacy | Mobile
Web02 | 2.8.141022.2 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100