How to convert EXCEL table to SQL query
Tips / October 4, 2015

Surely you have encountered problem with converting EXCEL document to database. It is no problem to insert few records to database via any GUI client. But what if Excel document contains thousands rows and tens of columns? There numerous tutorials how to achieve this by Exporting EXCEL document to CSV format and then importing CSV into database via GUI database client (for MySQL there is PHPMyAdmin and for Oracle there is SQL developer). Yes indeed, this way you can convert most Excel documents into database very easily and fast. While this method works fine with plain copy & paste table cells into database, you will encounter problem when you have to process data before insertion. CSV import will not solve this. Let’s have this table (first records is on second row in EXCEL document): customer_id first_name second_name address house_number 100 Peter Kadlec 5th Avanue 14 101 John Ballock Green lake 25/45 102 Abdul Habib 103 Tom Lurfurson Riverbound street 1050 104 Xiao Tung Peng Polgrad 5423/125   In general you just need to concatenate INSERT string with cell values. While doing this we can use conditions and other EXCEL functions to achieve result which would be impossible with CSV import…

How to change default file explorer directory (shortcut win+E) to This PC in Windows 10
Tips , Windows / August 5, 2015

After upgrade to Windows 10 you could encounter some minor changes in UI. One of most confusing decisions for me by Microsoft was to change function of shortcut win+E.  In older versions it launched This PC. I was using it since Windows 7 because I didn’t want to always double-click on This PC on desktop. I was happy until I upgraded to Windows 10 and now instead of launching This PC it launches some kind of “Recent files” called Quick Access. But don’t worry, Microsoft left us choice to set it back to normal. Buy I am really confused why would they change so old shortcut . So here is how you can set shortcut win+R to point to This PC:  Open any folder in explorer  Goto View > Options  Change “Open File Explorer to:” to This PC Thats it ! Enjoy your old habits.