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.
1 hour max
12 freelances font une offre moyenne de 1884 ₹ pour ce travail
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
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
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.
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
Good day! There are some versions of the decision: through linked server, through opendatasource and through openquery. We will choose option necessary to you.
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.
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.
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
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