I used sqlitebrowser to export a table to .csv, that worked great. I then modified the table and want to import it. That part isn't working. I select the .csv file, enter a new table name and click 'create'. Nothing appears to happen. No errors, no records, nothing.
I'm probably doing it wrong so how should I do this exactly? This involves a MediaMonkey database. I'm using the latest 2.01b browser.
Sorry, I see my Google OpenID is a bit unfriendly. My name is Sander.
Did you see your csv data displayed correctly in the window before you clicked "Create"?
Also make sure you don't have a BOM at the beginning of your CSV, as it appears the SQLite Database Browser doesn't play nice with the UTF BOM.
This post is old, but I thought I might be able to help someone else in the future.
I had the same problem. I happened to still have the csv file I had just created open in Excel. After I closed out and saved it started working. I think Excel hadn't really saved the file in the correct format until I closed out.