Find Jobs
Hire Freelancers

Embedded VBA code in excel to export data to SQL table

$30-250 USD

Imekamilika
Imechapishwa about 6 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
The project is two tasks: 1. Create an embeeded VBA macro that can send information from excel to SQL. 2. create excel sheet that can collect entire SQL list using VBA. Details: 1. I have an excel sheet that is used by many users daily. This sheet contains some values that I want compiled in a SQL table. The values should be picked from the excel sheet and entered as a new row in the bottom of the SQL table. SQL table shall expand with new entries and not be limited to less than 20000 rows. Values are 20 cells distributed on three sheets in the same workbook. If more simple - the data may be compiled in a hidden sheet before sending to SQL. VBA macro must be activated when pressing a button. When pressed button should lock and not be able to resend data from this workbook. 2. SQL server data retrieve is done with a new excel macro done in separate workbook. I have an SQL server account that the SQL part is to be set up in.
Kitambulisho cha mradi: 16481242

Kuhusu mradi

2 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Dear Client I am an experienced VBA programmer and database developer and have served the clients throughout the globe. I have reviewed your job post and it is quite inline with my skill set. I will therefore ready to proceed and will be waiting for your response. Warm Regards Z
$250 USD ndani ya siku 2
4.9 (139 hakiki)
7.8
7.8
2 wafanyakazi huru wana zabuni kwa wastani $165 USD kwa kazi hii
Picha ya Mtumiaji
Hello. Excl VBA has components for communicating with remote database server. In order to make sure it works with your particular server I'd need your server connection parameters. One point to clarify: by SQL table do you mean database table or something else? Best regards, Alexander.
$80 USD ndani ya siku 3
5.0 (18 hakiki)
4.5
4.5

Kuhusu mteja

Bedera ya DENMARK
Esbjerg, Denmark
5.0
4
Njia ya malipo imethibitishwa
Mwanachama tangu Feb 2, 2017

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.