Need help understanding this code. Upload range from excel to sql.

You are meant to call the ExportRangeToSQL function from your own subroutine or function, specifying the sourceRange, conString and table parameters with your particular arguments. For example:

Please Login or Register  to view this content.

Note that the sourceRange argument is expected to contain the table column names in its first row.

For the connection string, see http://www.connectionstrings.com/, or generate it yourself by using the Macro Recorder and doing a manual import data or database query from your database. The VBA code generated will include "ODBC;" or "OLEDB;" at the start of the connection string. Simply omit this part of the connection string from your own connection string.

The only change I would make to the ExportRangeToSQL code is to temporarily comment out the On Error statement whilst testing because that line will hide any errors and make it very difficult to debug any errors.