Click here to Skip to main content
13,554,782 members
Rate this:
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 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

Wait ur reply,

Thank you For Reply..
Nirav Kankhara,

[Edit]Removed Email address[/Edit]
Posted 7-Feb-13 2:03am
Updated 7-Feb-13 2:07am
__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

Rate this: bad
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..[^][^]

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..
using that dataset , in page wise you can use foreach condition inside of that you write the insertion query for inserting the data.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.180515.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2018
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