Can't import from .csv

Help
Anonymous
2011-01-03
2013-05-14

  • Anonymous
    2011-01-03

    Hello,

    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.

    Thanks!

     

  • Anonymous
    2011-01-03

    Sorry, I see my Google OpenID is a bit unfriendly. My name is Sander.

     

  • Anonymous
    2011-03-10

    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.

     

  • Anonymous
    2011-08-10

    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.