1. 

   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.
   
   Someone can help me
   
   thank you

    

   manu, May 7, 2007

   #1
2. 

   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 Active Member Licensed User

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

    

   manu, May 7, 2007

   #3
4. 

   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 Active Member Licensed User

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

    

   manu, May 7, 2007

   #5

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in