Writing tabular data from excel to sql server using VBA
Greetings all. I have this question for all experts.
In my excel workbook, I have many sheets, each sheet has tabular data
visible and some data are hidden. I want to save the visible tabular table to
a table in sql server. How can I do it without looping through each cell? I
want someting similar to "copyfromrecordset" when we retrieve data from SQL
server - so that I can write all visible tabular data from one sheet to SQL
server, than append the next sheet and on.
Thanks much!!!
|