Excell VB Macro to load data on SQL

I need some support on creating macro from excel to generate file from template that upload and download data to a SQL database.

it is not a large project but can go on step by step. not many hours a week but can last a couple of months.

attached you can find a sample file:

there are a couple of main table that can be stored on a SQL.

You need to:

1. create a sample SQL on Docker for development purpose.

2. Build template over the provided file.

3. develop VB macro to generate file from the template.

4. develop VB macro to upload data on SQL.

Aptitudini: Docker, Excel, SQL, VB.NET, Visual Basic

Vezi mai multe: how to import data from excel to sql server, excel vba insert into sql server, vba code to import data from excel to sql server, inserting data from excel to sql table, bulk insert from excel to sql server using vba, vba code to import data from sql to excel, how to import data from sql server to excel using vba, vba code to retrieve data from sql database, macro write data sql, load data sql server, load data sql excel, load data sql, load data json sql vbnet javascript, load data excel sql server using asp, load data excel sql server, load data sql file mysql, load data sql using asp, sql load data star schema, flare flash load data sql, input data vb macro

Despre angajator:
( 17 recenzii ) Torino, Italy

ID Proiect: #18928493

21 freelanceri licitează în medie 142$ pentru acest proiect


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(673 recenzii)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 4 zile
(310 recenzii)

I m interested ***************************************************************************************************************************************************************************

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(273 recenzii)

Hi there,I am Excel VBA and SQL expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it with Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(92 recenzii)

Hi, I'm an expert Excel / VBA / SQL / database / data import - export developer. Can do what you require (Excel upload/download to SQL Server). Please get in touch to discuss. Bests, Steve

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 30 zile
(42 recenzii)

Hi there, Sir i read your initial requirements and i have some question regarding to your excel vb project. please send me message so that we could discuss it further.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(21 recenzii)

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have already created vba program to upload data from excel to MySQL database and retriev Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(69 recenzii)

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(17 recenzii)

Hello, sir! I am happy to put my bid on your project. I have a full of experience with database processing in MySQL using Excel Formula and VBA. I have finished a lot of projects like this. I can show you one of th Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(15 recenzii)

Excel, VBA expert with over 9 years of experience. Can help to build a solution as needed & can start right away. Thanks

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(11 recenzii)

***Excel VBA*** Hi I have read your project description very carefully so I am confidence to complete your project I have finished lots of such projects successfully. I am an experienced and skillful Excel VBA de Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(5 recenzii)

Hello its my pleasure to meet you Almost of developers are saying that they have rich experiences in programming and they have power. As one of developers, I'm also saying that I am a guru of programming. I hope t Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(4 recenzii)

Hi there. I've read your job very carefully and understand what you want. I'm a Senior developer with 10+ years experience. I've high skills in Docker, Excel. Any of your requirements are welcome. I can start your Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(1 părere)

I am professional in VBA. I can complete this project within 3 days. please allocate me this project. Thank You.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)

Hi Let me support you understanding your demand better and creating the VBA macro needed. Understand better the datasource and it’s complexity to generate the SQL code for data extraction/upload can be an easy task b Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)

Hello . I am Student.I done your work with honestly. I am Searching job for a few month. I shall be very thankful to you.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)

Hi, Having recently decided to use this portal to provide my services, I would like to let you know a brief few points about myself : Been involved in data modelling, architecture, reporting, analysis, in MS Access, Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)

I am Govindasami i can do this with 100% success from India. We have great team with effective team mates. We process jobs by segregation and equal sharing within the team. Hence we achieve 100% customer satisfactions. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)

Hello, I will be glad to help you. For references, please find my linkedin profile below: [login to view URL] Thanks, Andrei

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)

Hi there, I saw your project and I'd like to make a bid on it. I have all the listed skills - I am an Excel VBA macro expert with deep experience in SQL Server, and have attached my SQL certification to my Freelancer.c Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)