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
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
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
 
FaustulusConnect With a Mentor Commented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here