Topic: Some hints and tips
Nice software.
I have been working and struggling with my data, and I think I have some hints and tips for users.
1) Warning: do not change the tablename after running a project. This action will delete existing data. You can only change tablenames before running a project.
2) After modifying a table (addding field or renaming field) save your project (save as) in a new empty directory.
3) To import existing data form Acces, there are also some other options than exporting your data to csv. (csv can give easily problems with decimal and comma characters).
a) In Acces you can export the data as dbf files (Dbase3). This format can also be imported with Sqlitestudio.
b) In Acces you can install an ODBC-SQL driver. Than you can link the sqlite tables in Access and update the data with updatequeries.
This is sligthly more complicated, but gives you maximum flexibility for data manipulation.