Microsoft Access Database Engine 2010 Redistributable --- No 64 bit ODBC Drivers in Windows 7 x64

In Windows 7 x64, the default Data Source(ODBC) will point to 64 bit DLL in “C:\Windows\System32”. If we want to run 32 bit Apps on 64 bit Windows 7, we need to use 32 bit ODBC Administrator Tool by launching “C:\Windows\SysWOW64\odbcad32.exe”. (# 1)

When we launch ODBC Data Source Administrator and want to configure Excel Files in User DSN tab,
we get an error message “Cannot find Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) ODBC driver”.
Although I know use the different ODBC administrator to configure 32bit or 64 bit DSN setting (#  1), I don’t when 64 bit ODBC driver for Office 2010 miss. In my intuition, the solution is very simple that reinstall ODBC driver!
So I download AccessDatabaseEngine_x64.exe from Microsoft Download Center(# 2) and double-click this file for installing it. But the warming message show up “Cannot install it besides remove the 32 bit installation of Office products firstly”.I don’t want to follow its suggestion because it will spend more time to remove and reinstall Office.
I search Web information by Google and find out it can be resolve by adding passive switch. The full command line is AccessDatabaseEngine_X64.exe /passiveAfter finish the above command and redo the ODBC configuration, its function is normal now.

Reference :
(# 1) Unable to create DSN for Microsoft Office System Driver on 64-bit versions of Windows
(# 2) Microsoft Access Database Engine 2010 Redistributable

Install 64-bit Oracle Client on 64-bit Windows 7

Last time, I install 32-bit PowerPivot 2012 on 32-bit Windows 7 to replace PowerPivot 2010. When I open Excel 2010 and select PowerPivot item, the remind message show up and ask me whether want to upgrade the workbook.
Of course, you have to press “OK” button so that the PowerPivot workbook will be showed up. In the moment, I follow the previous activity to execute refresh worksheet for retrieving Oracle Data but the result fail.
In this Error Message, it give me a suggestion either upgrading to 64-bit version or increasing memory. I choose upgrading to 64-bit version because the original 32-bit environment before replace PowerPivot version is normal so that it will be not enough memory.

For 64-bit environment, I need to install 64-bit OS, Office 2010, PowerPivot and hotfix with up-to-date. When finish the related Microsoft Prerequisite, the Oracle Client need to be installed then.
Download “Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) from Oracle Website and extract “win64_11gR2_client” compressed file to the selected folder. The extracted path will be “\client” and its setup file is under this path.
Executing "setup.exe” to begin the installation process of Oracle Client.
In Select Installation Type,select “Administrator” option next to click “Next>” button
Click “Next> “ button if we don’t need to select another language.
Keep the default Oracle Base and Software Location next to click “Next> “ button
If no any problem in Perform Prerequisite Checks, click “Finish” button to begin to install Oracle Client Software now.
The installation of Oracle Client almost is successful if no any surprise.

In the moment, we need to add a “tnsnames.oRA” file under the installation path as “c:\app\davidwa_wang\product\11.2.0\client_1\network\admin\” for creating an entry in this file to allows the ODBC driver to establish network connections to an Oracle Database.
In this file content, need to define “Data Source Name”, "Host” (by FQDN or NETBIOS name or IP), “Port” (default = 1521) and “Service Name”
After saving this file and opening Excel 2010 to execute PowerPivot Data Refresh, its function will be normal now.

Install Microsoft SQL Server 2012 PowerPivot for Microsoft Excel 2010

Microsoft PowerPivot for Excel is a exciting tool for analyzing data. It is very convenient for us to use in Excel because we almost don’t need to write any code for data analysis.
Since Microsoft Powerpivot for Microsoft Excel 2010 release, I have already used it in business work for a long time. Recently, I decide to change its version to 64-bit Microsoft SQL 2012 Powerpivot for Microsoft Excel 2010 because I get memory issue when run it. I think the 64-bit version can extend more memory than 32-bit one!

When I download “PowerPivot_for_Excel_amd64.msi” from this URL http://www.microsoft.com/en-us/download/details.aspx?id=29074 and execute it on Windows 7 64-bit version, I get a error message as follows:
I read PowerPivot Instructions and find out I forget to install “Visual Studio 2010 Tools for Office Runtime” in the moment.
So I download 64-bit version and install it next to update the last hotfix, I can install Microsoft SQL Server 2012 PowerPivot by Wizard now.
After installing PowerPivot next to open Excel program, I find out that PowerPivot item never show in menu.
I know need to do something to enable it.
Click “File” –>  "Options”, it will show up Excel Options window.
In Excel Options, click “Add-Ins” –> Select “COM Add-ins” in Manage menu –> Click “Go…” button and the COM Add-Ins window will show up.
In COM Add-Ins window, enable “PowerPivot for Excel” check box next to click “OK” button, the result is nothing happen --- that is “PowerPivot” item still disappear.
Why?
Because COM Add-Ins load behavior fail!
How to resolve this problem? Reinstall .Net Framework 4.0 again!
You can download .NET Framework 4 (Web Installer) or (Standalone Installer) from Microsoft Web Site.
After Installation is completed, don’t forget to check Windows Update again.
Redo the above process to enable “PowerPivot” check box, the load behavior is normal.
And PowerPivot item can be see now.
I think the key point is whether “Microsoft .NET Framework 4 Extended” exist.

Bulk rename utility

If you want to rename a extension of file, it is very simple to do it by right-click this file next to click "rename" in the menu. But if the file is very much, we need to repeat the same activity. I think it is not smart and spend more time for me. Whether has a simple method to do it? That is "Bulk Rename Utility".

To execute this utility and select the file you want to rename extension.

To change extension option from "Same" to "Remove".

You will see the final new name as green font in the screen.

If it is true what you want to do it, click "Rename" button to change it.

So do that you will see the files' extension is renamed right now. Save the time very much!

Although it is a little utility, it will be very convenient for us to do "Bulk Rename file" .

Active Office 2010 by KMS

When you open one document by Office 2010, the screen suddenly a alert message.  It express this product never is active and its function will be disabled after one day.

How to prove this?
In office menu, select File -> Help, you will see "Product Activation Required" in the right-panel.

How to register it by KMS command?
Open "Command Prompt" by Run as Administrator

Switch Path to C:\Program Files (x86)\Microsoft Office\Office14
(Install 32bit Office 2010 on 64 bit Windows 7)

Register kms Server by command as follow:
C:\Program Files (x86)\Microsoft Office\Office14>cscript ospp.vbs /sethst:KMSServerName

Active it by command as follow:
C:\Program Files (x86)\Microsoft Office\Office14>cscript ospp.vbs /act

 After done this, you return to the first step to confirm whether this product has been enabled. If it is true, congratulation, this product register is successful.