M manu Active Member Licensed User Longtime User May 7, 2007 #1 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
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
Erel B4X founder Staff member Licensed User Longtime User May 7, 2007 #2 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.
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.
M manu Active Member Licensed User Longtime User May 7, 2007 #3 Ok Erel But I want "Insert" into de table that exist, no Create.
Erel B4X founder Staff member Licensed User Longtime User May 7, 2007 #4 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.
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.
M manu Active Member Licensed User Longtime User May 7, 2007 #5 ok, good idea, I will prove it and I will already tell you. Thank you