ANmarS - Portfolio - TaShee3

Excel/VBA expert since Sep 1997 (19 years 11 months)

TaShee3    Added: 6/26/2015 | Created: 6/26/2015   



The new version having ability to fix connection if needed (same that found in Conny v2), along with more stable with bugs fixed
Get TaShee v2.7 here

This release have the ability to list all tables, then once that table has its own associated sheet created, user can modify any field, and upload changes.
Assuming that user in DB have read/write privilage.

Just like PowerPivot, TaShee, Lets you manage your SQL tables in Microsoft Excel
After you connect to a database in MSSQL server (SQL 10 is used, Server=SQLNCLI10), you can manage any table in that database and add, update, delete any set of rows.
This was part of my tool to manage my current website (ANmars.com) I have been using it for more than 4 months now and trying to update it as I can.

Watch the video for instructions on how to change settings for table and databse as well as how to access sheets D and Template, where you can modify hidden settings, if you feel you need to.

  • Table should be already exists in Database
  • Table should have first col as primary unique key (called ID)




Download (6.3 MB)

802 downloads | Last updated: 6/19/2017


Screen shots (6)