Dear members,

Does anybody have a method writing (in bulk) a named range or sheet to SQL server from Excel 2010?

I have 100000 to 300000 records I want to write to SQL Server from an Excel model and looping through each record loaded into an array is too slow.

Im suspecting I need to use a SqlBulkCopy method from Excel or similar but how?

I can do most things in VBA but SQL is not my strong side.

BR

Marc Bruun