Bulk Load Excel VBA

Hello

if we give the range as Sheet1$, it is working but i want the range to be given.

The worksheet name followed by a dollar sign, i.e. "Sheet1$", is an SQL Table reference. To reference a Range on the worksheet, follow the table name with the relative range address (No dollar signs) like this "[Sheet1$A1:C100000]".

Here is an example of adding the worksheet name automatically to the query string.

Please Login or Register  to view this content.