import .csv to SQlite

[manu]

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]

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.

 

[manu]

Ok Erel

But I want "Insert" into de table that exist, no Create.

 

[Erel]

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.

 

[manu]

ok,

good idea, I will prove it and I will already tell you.

Thank you