1 Reply Latest reply on Dec 7, 2011 8:21 AM by DonMitchinson

    Import CSV Data from a server into SQLite  - Help me do this or talk me out of it?

    trevorisjustso

      There is a portion of a MySQL database (no more than 500 records, 6 fields) that I would like to download into a local SQLite db every time a user signs in.

       

      The reason I want to do this is because there are a lot of weird  group by statements I want to chart, and I don't want to have to go back to the server over and over again.

       

       

      So what I've done is created an empty local SQLite db that matches my MySQL table. 

       

      Is there a way to import all these records without having to do a "foreach" statement?