import .csv to SQlite

Discussion in 'Questions (Windows Mobile)' started by manu, May 7, 2007.

  1. manu

    manu Active Member Licensed User

    Hi

    I am developing an application and i need imports with code a file in format csv to a base Sqlite.

    :confused: Someone can help me

    thank you
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    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.
     
  3. manu

    manu Active Member Licensed User

    Ok Erel

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

    Erel Administrator Staff Member Licensed User

    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.
     
  5. manu

    manu Active Member Licensed User

    ok,

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

    Thank you
     
Loading...