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.
15 freelancer đang chào giá trung bình £62 cho công việc này
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
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