VBA Fast Data Insert to Azure SQL

Want a simple yet super fast method to insert a list of data in array OR a Range to Azure SQL.

1. The method should be able to dynamically assign columns name.

2. The insert method must do a batch insert instead of one by one.

3. The method should be able to insert 10, 000 records within 20 seconds or faster.

4. Please don't use the ExportRangeToSQL method from the internet, I already have this method and the performance is not satisfy.

5. Please consider there will be over 50k data need to be bulk insert and it have to be fast (<= 120 seconds)。

6. The number of columns is about 55 columns.

Please let me know the way you plan to do for me to review then I will decide whether should let you handle this project

Kemahiran: Excel, Excel VBA, SQL, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: bulk insert from excel to sql server using vba, excel connect to sql server query, inserting data from excel to sql table, import data from excel to sql server using query, how to import data from sql server to excel using vba, vba code to retrieve data from sql database, excel vba update sql table, excel vba export data to sql server, insert data xml file sql, excel vba open data sql, fast data entering excel vba, radgrid editor data insert sql table, asp net web service data insert sql server, insert data csv file sql server, insert data xml file sql database vb net, insert data xml file sql server, sql server data insert, data insert sql, sql server fast data export, update azure sql excel vba

Tentang Majikan:
( 2 ulasan ) Johor Bahru, Malaysia

ID Projek: #18537298

Dianugerahkan kepada:


Hi, I have met this issue recently. I made a script that inserts poker betting weights into an Azure database from a CSV. First I started with single inserts but I quickly dropped the idea is it was very slow. I Lagi

$150 USD dalam 2 hari
(118 Ulasan)

3 pekerja bebas membida secara purata $77 untuk pekerjaan ini


Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately Br;

$55 USD dalam 3 hari
(19 Ulasan)

Hi, I am interested in your project and I am ready to start it after discussing the necessary details

$25 USD dalam sehari
(0 Ulasan)