Thanks XLD for this quick reply
my data is located in sheet named Backup
there are 30 column ( column header is named considering SQL requirement)
rows are nearly 5000.
so i want all of them should go to SQL at the moment

what changed have to be made in code given by u ?
should i name my range before running code ?

the above question arise coz in given code it wont specify from where to copy & what to copy & paste in SQL