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
     
    manu, May 7, 2007
    #1
  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.
     
    Erel, May 7, 2007
    #2
  3. manu

    manu Active Member Licensed User

    Ok Erel

    But I want "Insert" into de table that exist, no Create.
     
    manu, May 7, 2007
    #3
  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.
     
    Erel, May 7, 2007
    #4
  5. manu

    manu Active Member Licensed User

    ok,

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

    Thank you
     
    manu, May 7, 2007
    #5
Recent Posts
Loading...