• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

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

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
Murray Brown
Asked:
Murray Brown
2 Solutions
 
FaustulusCommented:
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
 
Rory ArchibaldCommented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now