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

Квалификация: Excel, Excel VBA, SQL, Visual Basic, Visual Basic для приложений

Показать больше 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

О работодателе:
( 2 отзыв(-а, -ов) ) Johor Bahru, Malaysia

ID проекта: #18537298



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 Больше

$150 USD за 2 дней(-я)
(118 отзывов(-а))

3 фрилансеров(-а) в среднем готовы выполнить эту работу за $77


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 за 3 дней(-я)
(19 отзывов(-а))

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

$25 USD за 1 день
(0 отзывов(-а))