Writing tabular data from excel to sql server using VBA

L

luvgreen

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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
Make a crosscast reprot from a tabular report 6
VBA to export large tables from Excel to SQL Server 1
Importing Excel data with macros to SQL server 1
Consolidation Table from Different Excel Tabs with Different Format 1
Push data from Excel to SQL Server 2
Plotting tabular data in an Excel graph? 5
Using VBA to change Crystal Reports settings from Oracle to SQL 0

Top