-
Excel to SQL Server (SqlBulkCopy method)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules