Re: [sqlite] Cannot export 'sqlite3' file to CSV

2020-02-27 Thread sky5walk
Easier still: Install https://nightlies.sqlitebrowser.org/latest/ Then open your sqlite database(s) directly within the browser. There you can run queries and/or export to csv. On Thu, Feb 27, 2020, 4:54 AM Shawn Wagner wrote: > Use the standard sqlite3 shell program: >

Re: [sqlite] Cannot export 'sqlite3' file to CSV

2020-02-27 Thread Shawn Wagner
Use the standard sqlite3 shell program: https://www.sqlite.org/cli.html#csv_export On Thu, Feb 27, 2020, 1:48 AM Rachael Courts wrote: > Hi All, > > I'm a couple of months into my PhD, studying bioacoustics. I am using > SQLiteStudio to open '.sqlite3' files, which I need to convert to CSV

[sqlite] Cannot export 'sqlite3' file to CSV

2020-02-27 Thread Rachael Courts
Hi All, I'm a couple of months into my PhD, studying bioacoustics. I am using SQLiteStudio to open '.sqlite3' files, which I need to convert to CSV files to import into MATLAB for further analyses. Currently I have attempted the data export function, selecting which database and table I would