Embedded VBA code in excel to export data to SQL table

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.


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.

Beceriler: Excel, Microsoft SQL Server, SQL, Visual Basic

Daha fazlasını gör: sync excel data sql table, vba code excel data word table, vba code import excel file data access table, data entry vba code excel, vba code read modbus data excel, update excel data sql table, excel vba code read serial data, vba excel export data csv, excel vba code download historical data yahoo, export data sql server 200 excel 2007, vba code import project data excel, code export data sql multiple sheet excel 65000, excel vba code pull internet data, vba code appliaction update data excel, vba code excel data analysis

İşveren Hakkında:
( 2 değerlendirme ) Esbjerg, Denmark

Proje NO: #16481242



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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 250%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(91 Değerlendirme)

Bu iş için 6 freelancer ortalamada $207 teklif veriyor


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 ta Daha Fazla

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)

Hi sir . Sir i have 7 years experience with your project skills i can provide you quality work on time. Can you please come to the chat box so we can easily discuss about project details.. Thank you

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

Hi, there. I've read your project description carefully and I’m interested in your project. I have more than 10 years of experience in programming. Please let me do your work completely and timely. Quality work is Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)

I make lots of VBA macro for company which allows them to run report automatically. If you give me a chance i will give you this within 1 week.

in %bids___i_period_sub_35% gün içinde266%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I'm Computer Scientist and ready to deal with various projects as VBA, macros, MS SQL Server , Excel programming Java projects, C#/C++, SignalR based applications, MySQL, MS SQL server, Database schema, Image processin Daha Fazla

in %bids___i_period_sub_35% gün içinde244%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)