Bulk insert into SQL Server with vba -


i trying insert lot of values sql server in 1 sql insert statement. using call of proc stock vba code example :

[... definitions of variables ...]      if not dico nothing         each current_id in dico.keys             set prm = .createparameter(cstr(current_id), advarchar, adparaminput, str_length, current_value)             .parameters.append prm         next current_id 

this code works when have single dictionary how when have array of dictionaries , can prm contains list of values (all values in dico) instead of 1 value (.parameters become list of lists)? there other methode that?

thank ,


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -