Hi I am developing an application and i need imports with code a file in format csv to a base Sqlite. Someone can help me thank you
Just create a Table control. Load the data using Table.LoadCSV Open an SQL database. Now use Connection.CreateSQLTable to save the table in the SQL database.
You can create a temporary sql table using CreateSQLTable. Now using INSERT INTO with SELECT add the temporary sql table to the target sql table.