Copy your SMS messages from iPhone to PC

[fijiman]

Tools Required

Firefox + SQLite Manager add-on for Firefox
Use iFile to locate and email SMS file to yourself...place the file on the Desktop for easy access...
Or any 3rd party program to browse your iPhone..iFunBox,WINscp..etc..etc. to locate and copy SMS file to Desktop

Var > Media > Library > SMS > sms.db

1. Rename sms.db to sms.sqlite
Note: if you are viewing the SMS file you downloaded and the extension is not showing...you will need to Uncheck "Hide Extensions" before renaming

2. Open Firefox and install the SQLite Manager add-on for Firefox, Restart firefox.
Goto Firefox drop down menu >Web Developer >SQLite Manager.
On SQLite Manager window click the open folder icon, locate and select sms.sqlite.

3. Click the Execute SQL tab and copy & paste the red bits into the "Enter the SQL" box
SELECT rowid, address, date, text FROM message ORDER BY date
Click "Run SQL"
All your text messages should now be viewable..

4. Hit the Actions button and choose Save Result(CSV) to file
Now you have all your sms in .CSV format saved for use with Excel.