Solved

Excel VBA/VB.net and Excel Tables (SQL Table data)

Posted on 2013-01-07
3
310 Views
Last Modified: 2013-01-07
Hi

I don't really use tables in Excel. Are they useful at all for viewing and updating SQL table data/
At the moment I either import SQL data or view it in a DataGridView form in Excel VB.net.
Are there any benefits of using Excel tables to do this
0
Comment
Question by:murbro
3 Comments
 
LVL 14

Assisted Solution

by:Faustulus
Faustulus earned 250 total points
Comment Utility
Neither do I. To my understanding tables are more in the nature named ranges. So, if you have several tables on one worksheet you can address them by their name and let each one have a cell referenced as Cells(1, 1). Each table has its own number of rows and columns and that makes it easier to add to it horizontally or vertically - a matter to addressing.
On the other hand, each cell within a table is also a cell within a worksheet. Whether you refer to it as Tables1.Cells(1, 1) or Cells(485, 15) should be a matter of personal preference. I can imagine that when you paste SQL tables to worksheets you are unlikely to place several of them on the same tab. In that case the question of using tables doesn't appear to come up at all.
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
Comment Utility
If you have a query linked to a SQL server, you're going to end up with a table.

In terms of just viewing data, it doesn't make a lot of difference (other than you natively get autofilters in place) but if you want to add calculated fields etc, tables are very useful.

For updating, it shouldn't make any difference as Faustulus said, other than it's simple to get the extent of your data if it's in a table.
0
 

Author Closing Comment

by:murbro
Comment Utility
thanks very much
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now