1. There is a database in MySQL. Is it possible to somehow import it into SQLite?

  2. There is a file in which each line is divided into two parts, for example Word $ Transfer. The first part is up to $ one column as the second part after $ is the second column. Is it possible to somehow load data from it into SQLite?

  3. There is a table in Excel Can I import data from it into SQLite?

In general, how quickly from some database to load data into SQLite? or can immediately save as SQLite?

    1 answer 1

    Here is a list of tools for converting

    http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

    For Excel and csv there is a resource

    http://converttosqlite.com/convert/ but I personally have not tried

    Also in the administrator of SQlite Studio there is a possibility to import csv (you probably will install some administrator for managing the database and there may also be an "Import" menu)