Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying and pasting tabular text data | Excel Discussion (Misc queries) | |||
extracting non-tabular data from webpage | Excel Discussion (Misc queries) | |||
How do you prepare monthly calendars in Excel from tabular data? | Charts and Charting in Excel | |||
'copy&paste' web tabular data into excel | Excel Discussion (Misc queries) | |||
Writing data to SQL server | Excel Programming |