Excel Sync to MSSQL Server
£10-90 GBP
Paid on delivery
Hi,
I need some VB / Macro to insert only new data into a Microsoft SQL server. Attached is a demo workbook which has a demo of the 2 sheets in excel which needs to be inserted into the database.
- Only new data should be inserted into the database
- Keys are User_id, Date & Time
- I need to be able to run the macro without interface from a user e.g. call it form another macro.
Looking for this to be completed as soon as possible please.
Thanks
John
Project ID: #15335854
About the project
14 freelancers are bidding on average £62 for this job
Hello, i can get this done using Macro itself. I see 2 sheets in the excel. Is that 2 tables in the database and i need transfer to both? Relevant Skills and Experience I'm 8 years experienced in freelancing VB. Pro More
Hello Sir, I see the project and the excel and I should be able to create the desired macro. Thanks Aanvik Relevant Skills and Experience Excel, SQL Server VBA Proposed Milestones £77 GBP - Milestone
Hey Client, Microsoft Sql Servers are my favorite day to day work. I have the best experience in Windows Server and I deliver on time. Please consider my bid. Thanks Relevant Skills and Experience Sql Server 2012 admi More
Vb macro could be written but it requires some time also if you can send the database table structure to run it locally Relevant Skills and Experience MSSQL, VB.NET
Hi, I am web developer experienced in designing and developing websites for my own projects as well as for clients. I have just graduated from Newcastle University studying Bsc Computer Science. I have seen your pos More
I have 11 years of working experience and an IT Expert using required skills within the project. Relevant Skills and Experience MS SQL Server, VBA, Macro and Excel Proposed Milestones £10 GBP - Identify worksheet row More