> On 23 Sep 2014, at 12:24am, Jungle Boogie <jungleboog...@gmail.com> wrote: > > I did this: > sqlite> create table august > (MERCHANT_ID,DBA,WHITELABEL_ID,ORDER_ID,TRANSACTION_DISPLAY_DATE,TYPE,STATE,TRANSACTION_AMOUNT); > sqlite> .separator "," > sqlite> .import portalUseMonthly_20140901.csv august > > doing: > sqlite> .mode csv > sqlite> .import C:/work/somedata.csv tab > (with correct values) > > Results in .schema assuming everything as text
because you defined them as text yourself. You need to put your column affinities in the CREATE command. Delete your existing table and try something more like this: > create table august > (MERCHANT_ID INTEGER, DBA TEXT, WHITELABEL_ID INTEGER, ORDER_ID INTEGER, > TRANSACTION_DISPLAY_DATE TEXT, TYPE TEXT ,STATE TEXT, TRANSACTION_AMOUNT > REAL); Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users