Terminé

SQL Server 2012, connect excel table with server in real time

Detail:

I have an excel file that I want to connect with SQL Server 2012 standard edition. Now the data in excel file keeps on changing every 10 seconds so I want the import process to keep running every 10 seconds. Very simple work, help me import it in real time and give me an idea how to do it.

Duration:

1 hour max

Compétences : SQL

En voir plus : ios server real time communication, real time web gps server android, real time log web server visualization, impact real time backup online processing system sql server, create local train time table excel format, real time quote excel, real time link excel, real time game flash server java, real time quotes excel dde, can real time quotes excel tradestation

Concernant l'employeur :
( 9 commentaires ) rajkot, India

Nº du projet : #8727720

Décerné à:

bspanovic

Hello I'm Microsoft Certified Database Developer. My Microsoft transcript you can check on this link: [login to view URL] I have 20+ years experience with Access and 15+ with Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% INR en 1 jour
(2 Commentaires)
1.4

12 freelances font une offre moyenne de 1884 ₹ pour ce travail

sumon355

Hello, I am very much interested to do this work as i have the experience on doing this type of work. I already did similar work few days ago, you may look "https://www.freelancer.com/projects/Excel/need-piece-VBA-cod Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 0 jours
(62 Commentaires)
5.7
mpalgeo

Hi I have been working with MSSQL for over 15 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have de Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(25 Commentaires)
5.1
vinaysinghh

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(5 Commentaires)
2.9
haseenamd

Hi,i have 8+ years of experience in SQL and SSIS, worked on all versions of SQL Server including 2000/2005/2008/2012. Let me know if you are interested.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(2 Commentaires)
2.4
LokeshNagendra

We can do it in three different ways to do it. 1) BCP- Bulk Copy commands 2) Import/Export - DTS Packages 3) SSIS packages. Based on our requirement we can chose either of the method. If we want to do it man Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
Papuas64

Good day! There are some versions of the decision: through linked server, through opendatasource and through openquery. We will choose option necessary to you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
ashishkumar22

I have 6 years of exp in sql server devlopment as well as data import and export task with access files. So I can provide you best help in that.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
singhsimran62

All services are Guaranteed & Trusted. Our expert team are always ready to give the best service & best quality work in right time, with 100% guaranty.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(0 Commentaires)
0.0
njakic

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
raviindia19

Hi, I am a BI professional and I can do this piece of work. I will create a SSIS package to load the data into Database and then will create a SQL job agent will will automatically execute the SSIS package to import th Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
fsarcosfree

Hi, this is a easy task, we need to install a component, we will use a package from integration services and configure a schedule and the process will execute automatically :) I invite you to contact so we can discu Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(0 Commentaires)
0.0