Sticky Notes seems straight forward means to keep notes that you need handy, like quick notes on command you use frequently. Unfortunately, once your notes reaches certain number, the program starts to lag in response i.e. your click or select will not register and you end getting frustrated. I been there and I resorted to copying and pasting notes from sticky notes to more awesome OneNote. I soon got tired of unresponsive sticky note and resorted to finding where the data is stored and how to retrieve it.
Following are my finding(or googling),
1. In Windows 10, Sticky notes stores data at %LocalAppData%/Packages\Microsoft.MicrosoftStickyNotes_8wekyb3d8bbwe\LocalState and inside file with extension *.sqlite.
2. Now to open the file we can use windows tools under sqlite.org download page. I used sqlite3.exe
3. Type in following commands after getting to folder where sqlite3.exe exists,
That is it, your sticky notes will be in the first column of the excel sheet that opens.
Following are my finding(or googling),
1. In Windows 10, Sticky notes stores data at %LocalAppData%/Packages\Microsoft.MicrosoftStickyNotes_8wekyb3d8bbwe\LocalState and inside file with extension *.sqlite.
2. Now to open the file we can use windows tools under sqlite.org download page. I used sqlite3.exe
3. Type in following commands after getting to folder where sqlite3.exe exists,
- sqlite3.exe - This is to get to sqlite prompt
- .excel - This is to specify that following command should show result in Excel
- SELECT * FROM Note - This command will display the table information in an excel
That is it, your sticky notes will be in the first column of the excel sheet that opens.
Great post! This is very useful for me and gain more information, Thanks for sharing with us.
ReplyDeleteeasyblogging
Technology
Wild West Gold Online - Sands Casino Resort
ReplyDeletePlay for real money at Wild West Gold Slot Machine. Play hundreds of the latest septcasino online slots kadangpintar at 제왕카지노 Sands Casino Resort in West Virginia. Claim your welcome bonuses.