View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
luvgreen luvgreen is offline
external usenet poster
 
Posts: 33
Default 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!!!