OK, here is the story: I posted my free audio player test result there, of course with the link back to my new website but without notice they changed it to a page on my competitor website. Even I am still the David and they are the Goliath :P but it’s hurting me since my free audio player test is not done in hours, it is done in weeks even more, it’s definitely not a spam! I’ve contacted them and they change it to the freeware publisher URL but still not a link to my website :D

You know I will not post the link to that website here, I don’t want to be blamed for a corruption of a good name but here is my comment there:

I’ve tested several music players with my Realtek Azalia Soundcard and a low end Edifier C2 speaker on WinXP including: CoolPlayer, Winamp (also with MAD Plugin), iCoolPlayer, Spider Player, Winyl, QuxPlayer, Aimp2, XMPlay, Xion, BEOPlayer even Samsung PC Studio Multimedia Player and of course WMP.

What I am looking for is the best quality of sound produced by those players omitting the user interface and the top 3 among them are:

Winyl (not sure what the engine is)
coolPlayer (MAD Engine)
XMPlay (BASS Library)
iCoolPlayer (I think it’s BASS too)

Winyl has the best sound quality on my system but lack of UI features (which is I do not care). Most players can not determine which one is treble, middle and bass (blurry in term of imaging) but this Winyl (IMO) can provide it with a solid bass kick, sharp character of each frequency group. So, if you have the same system as I have, maybe you should try Winyl.

Oh, one more thing: They said removal of any link on a comment depends on these:

1. The website linked to does not have a WOT (Web of Trust) rating of green
2. The link is to a .exe file
3. The link is spam or self promotional

It’s not a link to EXE File, it is maybe self-promotional but it’s a real test data there (not a spam!) I think I deserve that link back and how in the world a fresh new website has WOT? LOL :D

If this is the first time you heard about it then I am telling you that in my opinion, it is a very good software considering that it’s free.

The interface is good and the 3D rendering is done in real time, so every time you put an object such as furniture, doors, wall colors, room size, and even the roof, the 3D window will update it immediately.

The standard furniture included in the Sweet Home 3D setup package are enough for you to design a good looking home but furniture and other objects can also be downloaded from the internet. It’s fun, you should try it :)

I first spotted this one on cameranker.com, a pretty good looking site covering digital cameras and it also provides a ranking feature, familiar and easy to use filtering menu inluding the color of the camera but it lacks of advanced search and compare feature.

OK, back to 26x optical zoom on a compact camera. Compact means easy to use even I don’t think it’s easy to carry since the size is quite big but the most exciting is to know that it has 26x optical zoom to boost your zoom range deeper into the object details.

I don’t rely on one source so I checked the offifial Olympus USA and it the same specs as what cameranker said, more over it also features DUAL IMAGE STABILIZATION, ADVANCED FACE DETECTION, HIGH-SPEED SEQUENTIAL SHOOTING, PRE-CAPTURE and 12 megapixels with 2.7 LCD Screen.

Sounds like someone pays me to write this post right? :D No, I just excited to see a new tech product being released especially with this kind of specs. Have a nice day :)

If you are running Windows 7 Beta or Windows XP, you?ll need to back up your data (preferably on an external device) and then do a clean installation of Windows 7 RC. After installing Windows 7, you will need to reinstall applications and restore your files. If you are running Windows Vista, you can upgrade to RC.

There are some new features of Windows 7, such as the ability to watch and record live TV or navigation through the use of “touch,” but they may require advanced or additional hardware. The features and functionality you find in the pre-release product may not appear in the final version of Windows 7. Some notable Windows Vista features and components have been replaced or removed in Windows 7, including the classic Start Menu user interface, Windows Ultimate Extras, InkBall, and Windows Calendar.

I haven’t tried the beta and probably will not do it either with this RC version since I heard from many who had time to test that Windows 7 is no more than a repro of Windows Vista and this lead me to unproofed conclusion that Windows XP (I am currently using) is still - more or less - better than this latest version, but if for some reason you need or you want to try it - just go ahead.

I got curious about it and then I tried a simple test against Microsoft Query via Excel Import External Data feature, and Yes! Microsoft Query is not recognizing some of my test query parameters. If it does recognize the1st and the 2nd parameters, why it does not recognize the 3rd? I have no idea why, but I guess it’s a bug and they forget to debug it - so be it :D

Microsoft Query allows you to enter a hard coded SQL statement with parameters directly into the editor but it didn’t work as I described previously so we need to figure out another way to get around it.

As we know that most Database servers allow you to create a stored SQL statement for future use such as “query” on MS-Access and “stored procedure” on SQLServer. This ability gives me an idea:

What if I create an MS-Access query which can accept parameters and then call it from Excel’s Import External Data feature? Can Microsoft Query recognize all the parameters with this kind of method? The answer is Yes! Microsoft Query is recognizing all of the parameters.

Following are the steps on how to call stored procedure to Import External Data into Microsoft Excel. Some steps may look strange but based on my tests, each of them needs to be taken correctly,

___________________________________________________________________________

MS-ACCESS PART

1. Open the your Access DB
2. Create a Query by using SQL mode
3. Enter your SQL statement there (inluding the ? sign)
4. Save it as “MyQuery”

ODBC SETTING

1. Create an ODBC Connection to your DB

EXCEL PART

1. Navigate to Data -> Import External Data -> New Database Query
2. On the Database Tab, select the ODBC name you had created
3. Click OK
4. Click Cancel (just do it)
5. Select Yes if Microsoft Query ask you to edit the query
6. Click Close on Add Tables dialog (just do it)
7. Click SQL button on the toolbar
8. Enter {Call MyQuery(?, ?, ?)}
9. Click OK <- You will get an error message, Click OK to continue anyway
10. Enter each of your parameter
11. Close Microsoft Query
12. Insert The imported data on your worksheet
13. Select any cell on the area where you put the imported data then go to Data -> Refresh Data

___________________________________________________________________________

The question mark there is a sign that it can accept parameter. Let me give you an example to ease the understanding just in case this kind of stuff is a new one for you. So if you type an SQL statement like the one below into the MS-Access Query Designer (SQL Mode):

and then you save the query as “MyQuery“, when you call the query using the following syntax from Microsoft Query (SQL Mode):

That call will pass the parameter value (100) to “MyQuery” and in the background it will actually generate an SQL statement like the following,

That’s how it works, the question mark is replaced by the parameter value passed to MS-Access saved query.

TIPS IF YOU USE SQLSERVER INSTEAD OF MS-ACCESS

If you use SQLServer instead of MS-Access to Import External Data into MS-Excel, the method is the same but on SQLServer we call the saved query as “stored procedure” and here is the syntax to create it based on the example above:

So, if you are having the same problem with hard coded SQL Statement when you need to import external data into Microsoft Excel, you can try this method.

Good luck :) and don’t forget to check the discussion thread related to this issue on IT-Toolbox for more detail.