Merge Tables Wizard for Excel

Say, you need to compare two Excel spreadsheets, find the updates or new columns and get them to your main table for further analysis. The problem is it's too time-consuming and doesn’t guarantee that all the important data are included.

MergeTables Wizard for Microsoft Excel is a handy alternative to Excel Lookup and Vlookup functions that will automatically compare 2 sheets you specify as master and lookup, uncover matching rows and update your first table. All it takes is five steps and less than a minute.

In addition, you can use one or several columns as matching criteria, add new columns to the main table or update the existing ones, highlight or filter the modified entries.  

How Merge Tables Wizard works

Forget about manual checking of two Excel tables for matching data!

•        You just select the Master Table - the one that you want to update.
•        Choose the Lookup Table where the add-in will look for the new data.
•        Pick matching columns or those with common index fields in both spreadsheets.
•        Choose the columns to be updated or added to the main table. 
•        Adjust the merge results using additional options on the last step.
• 
  

Finishing touch to the merge results

There are some additional options that you may find useful. For matching rows this tool will set the background color of updated cells, update only empty cells in your main table or update only if cells from the lookup table contain data.

Also you can tweak the following options for non-matching rows: Clear background colors of Non-updated cells or Add non-matching rows to the end of the Master Table.

You can also mark the merged data by adding a status column to the master table that will indicate rows as: Updated, Non-updated or New row. Take the advantage of this option if you want to have this information at hand even after sorting the rows or changing the layout of your worksheet.

Use Merge Tables Wizard to join data from different sources, find and merge matching data from two Excel tables in seconds.

Add-in Express for Microsoft Office and .net

Add-in Express for Microsoft Office and .net is the all-in-one platform for developing any types of Microsoft Office extensibility projects with minimal coding

Add-in Express allows developers to easily create professional extensions for Microsoft Office such as COM add-ins, smart tags, real-time data servers, Excel Automation add-ins and XLL add-ins. It provides special components for integrating applied code with all applications from the Microsoft Office family including Outlook, Word, Excel, Visio, Access, PowerPoint, MapPoint, FrontPage, InfoPath, Project and Publisher.


Add-in Express equips you with a strong solution architecture and coherent programming model complemented by a combination of .net components, designers and deployment tools that will free you from a nightmare of tedious coding and ensure a quick and perfect result.


Using Add-in Express visual designers, wizards, modules and components you can create version-neutral, secure, isolated, deployable and automatically updatable Office extensions with your own toolbars, menus, ribbons, form regions, task panes and keyboard shortcuts in minutes. All available Office versions from 2000 to 2010 and Office suites from Student to Enterprise are supported.


Key Benefits

•  Visual designers instead of coding. You use visual designers to customize Office menus, toolbars, ribbons, task panes, forms, windows, regions, option and property pages, to add custom and customize built-in toolbars, main and context menus for all Microsoft Office applications. 
• Version-neutrality. You develop one extension for all available Office versions (2000 - 2010) and Office suites (Student, Home, Standard, Professional, Professional Plus, Ultimate, Enterprise). No need to create different projects for different Office versions since Add-in Express supplies you with a version-neutral core and Office primary interop assemblies (PIAs). 
• Effective project architecture. Add-in Express provides you with ready-to-use solution templates that accumulate our long-term experience in development and deployment of Office solutions. The Add-in Express architecture makes your Office solutions secure, isolated, managed, deployable and updatable with your minimal efforts. 
• Advanced Outlook customization offers a unique GUI for your Outlook plug-ins. Use Advanced Outlook Forms and Views Regions to embed custom .NET forms into Outlook views and forms. Populate Outlook windows with any built-in or third-party controls, including e-mail, task and appointment windows, Reading pane, Navigation pane, To-Do bar, etc. Completely replace Outlook views with your .NET forms (as Outlook Today), add you own property pages to Outlook folders, build your own Outlook Navigation Pane shortcuts and do lots of other things to extend the Outlook GUI. As a result, you get full-featured Outlook plug-ins that work on all Outlook versions, across 2000 through 2010. 
• Special features for extending the Excel GUI. You can build your own real-time data servers and new worksheet functions for Excel 2000 – 2010. Add-in Express supports two ways of creating custom worksheet functions, using Automation add-ins and XLL add-ins. 
•  Advanced Office task panes for Microsoft Office 2000 - 2010. Being more flexible than native Office task panes, the Advanced Task Panes let you customize the main Excel, Word and PowerPoint windows with native .NET forms that can be resizable, hidden, minimized (like the Outlook To-Do Bar) and dragged between task pane docks. 

• Easy deployment. With Add-in Express the deployment of your Office extensions is so easy that you forget about it. Each Add-in Express solution contains a setup project with all necessary prerequisites. Several technologies and installation types to deploy and redeploy your solutions are supported: Windows Installer projects, ClickOnce publishing and MSI based web-deployment. 
• True RAD - you write applied code only. Add-in Express is completely based on the Rapid Application Development approach and reduces the time you used to spend on Office extensions development at least by half. You write applied code only, Add-in Express does everything else. 

Main Features

• Add-in Express is fully founded on the Office extensibility technology and extends it with unique features which make Office development fast, easy and effective. You use visual designers and special components to:
• Add custom and customize built-in toolbars, main and context menus with your controls, items and sub-menus for all Microsoft Office 2000 – 2003 applications. 
• Add new or customize existing tabs for Office 2007 and Office 2010 Ribbon UI. 
• Build the Quick Access Toolbar and the Office Menu for Microsoft Office 2007. 
• Build the Backstage View for Microsoft Office 2010. 
• Add any .NET controls onto Office toolbars. On all versions of Outlook, Word, Excel and PowerPoint, you can place any built-in or third-party controls on Office toolbars. Your own toolbars can be populated with grids, tree views, list views, user controls, forms, etc. 
• Develop in one project smart tag libraries with multiple, shared or dynamically created recognizers. 
• Program Excel real-time data servers and tree-viewed real-time data topics. 
• Develop new Excel worksheet functions (UDF). 
• Create Excel Automation add-ins and XLL add-ins. 
• Access any Office objects, their properties and methods, handle their events.

Supported IDEs

• Visual Studio 2005, 2008 and 2010
• Visual Basic Express 2005, 2008 and 2010
• Visual C# Express 2005, 2008 and 2010

Related Links

• Add-in Express for Office and .net home page
• Feature tour - a quick overview of key features
• Video: Skip coding your custom Office components, simply draw them!
• Video: Create an Office shared add-in, end-to-end demo

My experience

Daniel Calbimonte is a Microsoft Most Valuable professional and a Microsoft Certified Trainer in SQL Server.

https://mvp.support.microsoft.com/communities/mvp.aspx?name=Daniel+Calbimonte

 

With 9 different Microsoft Certifications in SQL Server, C# and Windows Server. He has 11 years of experience in Microsoft SQL Server and Office.

He developed training Material for SQL Server Administration and Business Intelligence, Analysis Services,

He also helps people in the MSDN page:

http://social.msdn.microsoft.com/profile/dani671/?type=forum

Writter for the MSSQLTIPS.com and  SQLServercentral





He worked as a Quality Engineering Manager, Developer and as a Educational Trainer in different conferences, IT Academies. He is also a Technical and a Video Author for www.profexor.com

His experience includes banking, insurance, HR, government, oil industries, e-commerce, software development and universities.

Some companies that Daniel worked for are:

 

What is powershell ?

Many people wants to know what is powershell ?.

Is it a more powerful cmd ?

Is it a powerful environment ?

If I have Windows 2003, can I use powershell or it is only for Windows 2008 ?

If  you have worked with UNIX and Linux, powershell is a natural need that Microsoft required.

Visual Basic was not as powerfull as the born shell, c shell to interact with the OS.

Microsoft noticed, that it was necessary a more powerful shell to support  variables, loops, functions, etc.

Actualmente el cmd era muy limitado para la programación. El Visual Script surgió como una alternativa para automatizar tareas, pero es relativamente lento y se necesitan muchas líneas de código para tareas sencillas que en otros lenguajes como PERL se harían mas fácilmente.

Getting started

Let start with the hello world:
PS C:\> echo ¨Hello world¨

Use variables in powershell
PS C:\>$var=hola mundo
PS C:\>echo $var

How to get help
There are 3 ways to do it:
PS C:\>get-help dir
PS C:\>man dir
PS C:\>help dir

How to get the list of all the commands in powershell
PS C:\>get-help *

More examples about commands in powershell:
http://technet.microsoft.com/en-us/library/dd347701.aspx


Show the drives in Powershell
Get-PSDrive.
This command let you show the different drives.

Use aliasThe alias let you rename or create your own names for the commands.

PS C:\> set-alias get-drive get-psdrive

This command create an alias to the get-psdrive. The new name created for the command is get-drive.
If you execute it, you will have the same results than the get-psdrive






Finalmente, salvamos el archivo y cerramos y abrimos el powershell


Registry


In order to go to the registry in powerhsell use this:

PS C:\> cd hklm:

In order to return to the c: drive use this command:

PS C:\> c:

To clean the screenshot use cls:

PS C:\> cls

If you need to go to the registry drive again use the cd.

PS C:\> cd hklm:

If you want to go to a specific path:

PS HKLM:\> cd software\clients\Calendar\Microsoft*\
Protocols

The command used to create a new registry with powershell is the following:

PS HKLM:\software\clients\Calendar\Microsoft Outlook\Protocols>mkdir reg_nuevo

In order to return to the root use this commad:
PS HKLM:\software\clients\Calendar\Microsoft Outlook\Protocols>cd /

To list the children of the HKLM folder:

PS HKLM:\>Get-ChildItem
PS HKLM:\>ls
PS HKLM:\>gci
PS HKLM:\>dir


If you want to return to the c drive:
PS HKLM:\> c:

Process

In order to display the list of processes
PS C:\> Get-Process

In order to stop a process
PS C:\> Stop-Process -processname [process]


If you need to list the services

PS C:\>Get-service


In order to start a service use this commad:


PS C:\>start-service [service_name]

In order to stop a service use this commad:

PS C:\>stop-service [service_name]



Powershell scripts
By default the scripts are disabled. You can try to execute with this command:

PS C:\> ./prueba.ps1

If you need to enable the policies to run scripts, use this command:

PS C:\> set-executionpolicy unrestricted
Once enable, try again

PS C:\> ./prueba.ps1

How to create a batch file to call a ps script

Step 1.
Create a ps1 file.
Filename: creardir.ps1
Content: mkdir Daniel

Step 2. Create a file with the .bat extension
Filename: createdir.bat
Content: powershell.exe -command .\creardir.ps1


In order to create an event in the event viewer:

PS C:\Documents and Settings\user> EVENTCREATE /T ERROR /ID 1000 /L APPLICATION /D "Test Error"


In order to see the event in the application log:
PS C:\Documents and Settings\user> Get-EventLog -logName "Application"

Geek love with Google

How can a geek express his feeling ?

Watch  the video to know how.

<iframe allowfullscreen="" frameborder="0" height="315" src="http://www.youtube.com/embed/WTGUjRJiqik" width="560"></iframe>

SQL Server History

After Googling a little bit, I found this interesting video about SQL Server History:




I feel old.

SQL Server 2012 comes on March 7

The new SQL Server will come on March 7.
What is new in SQL Server ?.

A lot of stuff:

• Suppport for Windows Core editions
• Sequences
• Throw statements
• New Business Intelligence tools
• SQL Server Data tools
• Itanium support removed
• Integration with powershell 2
• Tabular projects
• Powerpivot for Excel
• Powerpivot for Sharepoint
• Etc

If you want to know more information about SQL Server 2012, visit this site:

http://www.sqlserverlaunch.com/ww/Home